How do I create a calculated column with IF?
0
I want a 'Margin band' column: High, Low or Loss depending on profit.
1 answer
0
Accepted answer
Add a calculated column such as Margin band = IF([Profit] < 0, "Loss", IF([Profit] / [Sales] > 0.2, "High", "Low")).
More detail: DAX measures and calculated columns
Your answer
Know the answer? Sign in to help. It's free.