SQL CASE statement equivalent to in DAX

[Anonymous]

hi , I m developing a powerbi matrix report and my row data is a look up column and I have to group  some values into one value ..

example - IF the column has values AB or BC or
CZ then display as NEW, IF values are FE of ZS then OLD Else NORMAL

In SQL I can easily write CASE statement . My data source is sales force . can anyone plz give me the DAX query to achieve my requirement so tat I can then use tat column in my matrix rows ?

[Anonymous]

SWITCH TRUE worked like a magic to me.

[selimovd · Accepted solution]

Hello @Anonymous ,

you can realize that in DAX with the Switch function and a TRUE() statement.

Check the following article:

DAX - The Diabolical Genius of “SWITCH TRUE”

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up
👍

Best regards
Denis

Blog: WhatTheFact.bi