Power BI: Multiple condition in single if condition

Question

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? 

Answer 1

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: