YOY percentage above 100

DAX DAX Calculations
1

Hi DNA Team,

I need some help with this. I have calculated the YOY percentage change.
However, I want to show the result only if the percentage change its between 0-100%(positive or negative ). if its above 100% then N/M (not meaningful )should appear. Presently having above 100% showing with my data.

YoY % Total Sale Growth =
DIVIDE( [Total Sale CY vs PY] , [Total Sale LY])

Thanks

2

Hello @Tee1,

Thank You for posting your query onto the Forum.

Well you can absolutely achieve this type of result using the “SWITCH( TRUE() )” function with the logic stated as below as an example -

Measure = 
SWITCH( TRUE() , 
       [YoY % Total Sale Growth] > 0 && [YoY % Total Sale Growth] <= 1 , [YoY % Total Sale Growth] , 
"N/M" )

I’m also providing some of the links of the videos available onto our EDNA YouTube channel pertaining to this topic.

Hoping you find this useful and meets your requirements that you’ve been looking for. :slightly_smiling_face:

Thanks and Warm Regards,
Harsh

3

Thanks very helpful.

4

Hello @Tee1,

You’re Welcome.:slightly_smiling_face:

I’m glad that you found it helpful.

Thanks and Warm Regards,
Harsh