Back

Explore Courses Blog Tutorials Interview Questions

Power BI: Multiple condition in single if condition

0 votes
2 views
in BI by (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

0 votes
by (22.5k points)
edited by

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: 

 

Related questions

0 votes
1 answer
How should I write multiple IF statements in DAX using Power BI Desktop?
asked Nov 30, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
Power BI, IF statement with multiple OR and AND statements
asked Feb 22, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
How to turn the drillthrough filter off in a single visual in Power BI?
asked Feb 28, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
Delete single row in dataset in power BI through app
asked Dec 27, 2020 in BI by Chris (11.1k points)

Browse Categories

© COPYRIGHT 2011-2023 INTELLIPAAT.COM. ALL RIGHTS RESERVED.

Download Salary Trends Now !

Learn how professionals like you got up to 100% Salary Hike.

...