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.
I have data that looks like this :
Name | Group 1 | Group 2 | Group 3 |
Joe | 1 | ||
Moe | 1 | 1 | |
King | 1 | 1 | |
Penn | 1 | ||
Zhee | 1 |
And would like create a new flag measeure like this ( returns first empty row by group):
Name | Group 1 | Group 2 | Group 3 | Flag |
Joe | 1 | Group 1 | ||
Moe | 1 | 1 | Group 3 | |
King | 1 | 1 | Group 2 | |
Penn | 1 | Group 1 | ||
Zhee | 1 | Group 2 |
Thanks for your help
Solved! Go to Solution.
Hi @Diimoo1
Formula below will achieve your requirement.
Measure = IF(ISBLANK(MAX([Group 1])),"Group1",IF(ISBLANK(MAX([Group 2])),"Group2",IF(ISBLANK(MAX([Group 3])),"Group3")))
Best Regards
Maggie
I have data looks like this:
Name | Group 1 | Group 2 | Group 3 |
Joe | 1 | ||
Moe | 1 | 1 | |
King | 1 | 1 | |
Penn | 1 | ||
Zhee | 1 |
Would like create flag column/measure the return the first blank celll: Result will look like this:
Name | Group 1 | Group 2 | Group 3 | Flag |
Joe | 1 | Group 1 | ||
Moe | 1 | 1 | Group 3 | |
King | 1 | 1 | Group 2 | |
Penn | 1 | Group 1 | ||
Zhee | 1 | Group 2 |
I tried to capture by filtering but no luck. Please see if you can be help on this Dii
Hi @Diimoo1
Formula below will achieve your requirement.
Measure = IF(ISBLANK(MAX([Group 1])),"Group1",IF(ISBLANK(MAX([Group 2])),"Group2",IF(ISBLANK(MAX([Group 3])),"Group3")))
Best Regards
Maggie
Thanks Maggie..That works
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 |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |