Forum Discussion
Solved
Convert 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 ([Acti...
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!
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!