How can I convert this SQL CASE to DAX measure

[Anonymous]

AND (CASE

                 WHEN column1='New Lease' then column2

                 WHEN column1='Move-out' then column3

                 WHEN column1='Renewal' then column4

                                                                                     end ) > 0

How can I convert it into a DAX measure?

[v-stephen-msft]

Hi @Anonymous ,

The "CASE WHEN" in SQL is similar to SWITCH() in DAX.

The measure can be created like

SWITCH(MAX('tablename'[column1]), "New Lease", MAX('tablename'[column2]),"Move-out", MAX('tablename'[column3]), "Renewal", MAX('tablename'[column4]))

SWITCH function (DAX) - DAX | Microsoft Docs

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MahyarTF]

Hi,

You could use nested IF or Switch function in Dax based on your scenario 

[NandanHegde · Accepted solution]

Hey,

you can use Switch for this scneraio :

https://community.powerbi.com/t5/Desktop/CASE-Statement-to-DAX/m-p/185548