Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

IF statement - problem - need at row level and not calculated column

Hello I need to figure out how to get an If statement to work at the row level (iteration per row).  It cannot be a calculated column, it needs to be a measure. The simple if statement (that does n...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Thank you very much.  It is so obvious now LOL  It is very time consuming to learn this through you tube so I greatly appreciate the help

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Anonymous

With a little modifiaction of your formula, I can use the measure correctly.

Please have a look at my test, if you have any problem in your scenario, feel free to ask me.

measure = If (MAX('Sales History'[Attribute])= "MMBTU", [Actual MMBTU],[Actual/MMBTU])

 

 

 

Best Regards

Maggie

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thank you very much.  It is so obvious now LOL  It is very time consuming to learn this through you tube so I greatly appreciate the help