Forum Discussion
anjanikumar
Helper III
Helper IIIConvert To DAX !!
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
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!
1 Reply
- PabloDeheza
Solution Sage
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!