jeudi 22 août 2019

Power BI, IF statement with multiple OR and AND statements

I have a table and want to create a new column based on some columns in the table using multiple statements.

I want to do something like this:

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

How would I code this in DAX?

Aucun commentaire:

Enregistrer un commentaire