topic Multi Condition Statement to Set a Variable in DAX Commands and Tips

Multi Condition Statement to Set a Variable

hubnerj — Wed, 26 Mar 2025 19:45:23 GMT

I am looking to create a variable called DIFF that is set to a specific number based on the value of a text string called STATUS. Basically -

If STATUS=Submitted then DIFF=14

If STATUS=Active then DIFF=21

If STATUS=OnHold then DIFF=28

What would be the syntax for this? Thanks in advance.

Deku — Wed, 26 Mar 2025 20:20:46 GMT

Var diff =

Switch(

Selectedvalue( table[status] ),

"Submitted", 14,

"Active", 21,

"On hold", 28

)

hubnerj — Wed, 26 Mar 2025 21:09:56 GMT

Worked great, thanks!