Forum Discussion

DMB90's avatar
DMB90
Icon for Helper II rankHelper II
4 years ago
Solved

Expression For If Not and If It Is

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.

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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]) )

  • DMB90's avatar
    DMB90
    Icon for Helper II rankHelper II
    4 years ago

    Sorry, I meant if it's NOT "No Population" and the other column says "Complete" then follow the previous statements.