Power BI: Multiple condition in single if condition

Question

asked Dec 31, 2020 in BI by Chris (11.1k points)

I am having a fields Amount, Condition1, Condition2

Amount  Condition1   Condition2
----------------------------------
123     Yes          Yes
234     No           Yes
900     Yes          No

How can I calculate 20% on condition?

1 Answer

Vamsee Krishna · Answer 1 · 2020-12-31T08:43:58+0000

Try the following DAX query

new_column = IF(Conditition1 = "Yes", IF(Condititon2 = "Yes",Amt * 0.2 ,0), 0)

Interested to Learn Power Bi in detail? Come and Join the Power BI course by Intellipaat.

Meanwhile, get an introduction to Power BI, from the following video tutorial: