Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm trying to identify service # that includs two service names A AND B. My table is
Service | Service# |
A | 1 |
B | 1 |
A | 2 |
A | 5 |
A | 3 |
B | 3 |
B | 4 |
I'm a new user to Power BI. If this question is duplication of previous post(s). Please direct me to right track. I appreciate your help ahead.
Hong
Solved! Go to Solution.
@ritar_li , A new column
new column =
var _1= calculate(distinctcount(Table[Service]), filter(Table, [Service#] =earlier([Service#]) && [Service] in {"A", "B"}))
return
if(isblank(_1), false(), true())
@ritar_li , A new column
new column =
var _1= calculate(distinctcount(Table[Service]), filter(Table, [Service#] =earlier([Service#]) && [Service] in {"A", "B"}))
return
if(isblank(_1), false(), true())
Hi, dear supper user,
I have a new issue just came out related to question above. My company just dropped off the service B after 9/1/2021. As a result, the vales in colume after 9/1/2021 turn in False. I have problem to fomulate a calculation to experess this time point change. I greatly appreciate your help.
Hong
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |