Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |