Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (11.1k points)

I want to create a table and create a new column based on columns based on multiple statements

Which looks like this

NewColumn  = if( (colA>colB and colC=0)
             or (colD >colE and colF = 20)
             or colG = "blue",
             "True", "False") 

Is there any possible way to code this DAX? 

1 Answer

0 votes
by (22.5k points)

Use the following measure

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

If u want to learn the tool in-depth, then come to us and sign up for this Power BI Certification      

Related questions

0 votes
1 answer
0 votes
1 answer
asked Mar 28, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
asked Nov 21, 2020 in BI by Chris (11.1k points)
0 votes
1 answer
asked Feb 21, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
asked Dec 31, 2020 in BI by Chris (11.1k points)

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...