Convert To DAX !!

[anjanikumar]

case
when ( ?Sort Prompt? = 'By Cases' )
then ( [ALL Cases] )
when ( ?Sort Prompt? = 'By Skus')
then ( [CY SKU] )
when ( ?Sort Prompt? = 'By Active Skus')
then ( [CY Active SKU] )
else
([Active SKU Change] )

this cognos Statement please convert to dax.

end

[PabloDeheza · Accepted solution]

Hi there!

use SWITCH statement like this:

SWITCH(

TRUE(),
?Sort Prompt? = "By Cases", ( [ALL Cases] ),
?Sort Prompt? = "By Skus", ( [CY SKU] ),
?Sort Prompt? = "By Active Skus", ( [CY Active SKU] ),
([Active SKU Change] )

)

Let me know if that helps!