Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Metric Switch Formatting Error

I have two metric switch statements. One switch returns the current week data, the other switch is the prior 6 week data. I need to create a Varience between the two, so I need to subtract the two me...
DAX
Formatting
Metric Switch
Switch Metric
  • Anonymous's avatar
    Anonymous
    5 years ago


    I just figured out a way to resolve it after trying every possible way. I was able to create a third metric switch statement that did the subtraction and formatting in the last metric switch used. Simple = Difficult haha

    Thank you for all your help and suggestions! Radhika2605 Fowmy 

     

Radhika2605's avatar
Radhika2605
Icon for Helper II rankHelper II
5 years ago

Hi Anonymous ,

 

I believe the issue is because the result of Format function is a String and when you are subtracting switch then you are for some values subtracting string from string which is not possible.

 

Is it possible for you to multiply the result of calculation in measures like Cancellation %, Productivity % by 100 and format then using options on the Column Toold Ribbon from the top to say that it is a % instead of using Format function in switch?

 

Could you please mark this as a solution if this answers your query.

 

Thanks

Radhika