Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

If Statement based on string value

Hello, Quick need have two measures. Measure A and Measure B. Want to write an if statement that if table[status]="PR" then Measure A else Measure B. Status has only has 3 distinct values in million ...
  • Ashish_Mathur's avatar
    5 years ago

    Hi,

    Does this measure work?

    TimelyMeausre=if(max(table[status])="PR",MeasureA, MeasureB)