How do I create a calculated column with IF?

Asked Viewed 33 times Solved
0

I want a 'Margin band' column: High, Low or Loss depending on profit.

DAX and Transform AI Insights 365 Team

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

AI Insights 365 Team ·

Your answer

Know the answer? Sign in to help. It's free.