Month over Month Varaince

[varuntableau5]

HI All,

Need to do Month over Month calculation and display variance in the chart via conditional formatting . Can any one help me with this solution i tried using quick measures its not working .Looking forward to the solution or any hints

[Melissa]

Hi @varuntableau5,

For tips on obtaining a quick and accurate response see this topic:
https://forum.enterprisedna.co/t/does-your-support-question-have-everything-required-to-be-answered-effectively/3953

.
You can use the Search option in the upper right corner to find more related / relevant content.

https://forum.enterprisedna.co/t/the-best-time-comparison-function-dateadd/4927

https://forum.enterprisedna.co/t/time-intelligence-using-dateadd/3323

Conditional format negative percentages

@suzanne, @MudassirAli beat me to it. I’ve got a variation on his approach that simplifies the conditional formatting screens a bit: Cond Format Mom% = SWITCH( TRUE(), SELECTEDVALUE( 'Table'[MoM %] ) < -0.50, "Red", SELECTEDVALUE( 'Table'[MoM %] ) < -0.35, "Orange", SELECTEDVALUE( 'Table'[MoM %] ) <= 0, "Yellow", "Black" ) Now instead of Conditional Format by Rules, use By Field and set the field equal to your measure: [image] and Voila! [image] One other nice thing ab…

I hope this is helpful.