Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I am trying to build a measure that says:
If column A does not say "No Population" then look and see if column B says "Complete" and if both are true then say "Ready for Review" and if not then pull whatever else is in Column B.
Solved! Go to Solution.
Sorry, I meant if it's NOT "No Population" and the other column says "Complete" then follow the previous statements.
@DMB90 , a New column would be best
but for a measure
if( max(Table[A]) = "No Population" && Max(Table[B]) = "Complete", "Ready for Review" , Max(Table[B]) )
User | Count |
---|---|
80 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |