Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
97 | |
97 | |
73 | |
72 |