Forum Discussion
Time Intelligence
You need to create additional measures fo different granilarity and then create measure with SWITCH function:
GAP_Chg = SWITCH ( TRUE (), ISINSCOPE ( DATE_DIMENSION[Month] ), [GAP_Mom_Chg], ISINSCOPE ( DATE_DIMENSION[Quarter] ), [GAP_QoQ_Chg], ISINSCOPE ( DATE_DIMENSION[Year] ), [GAP_YoY_Chg] )By using this measure in the matrix/chart you can easily change MoM to YoY etc.
_______________
If I helped, please accept the solution and give kudos! 😀
Hi andybamber
You can use INSCOPE function to easily change the measure based on the level on which user is.
Please check this article: https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
If you can then please share your measure and I will help you.
_______________
If I helped, please accept the solution and give kudos! 😀
Hello There!
this is what i'm using...
GAP_Mom_Chg = CALCULATE([Gap_Rec_Need]) - CALCULATE([Gap_Rec_Need],PREVIOUSMONTH(DATE_DIMENSION[Date Key]))
Cheers
Andy
You need to create additional measures fo different granilarity and then create measure with SWITCH function:
GAP_Chg = SWITCH ( TRUE (), ISINSCOPE ( DATE_DIMENSION[Month] ), [GAP_Mom_Chg], ISINSCOPE ( DATE_DIMENSION[Quarter] ), [GAP_QoQ_Chg], ISINSCOPE ( DATE_DIMENSION[Year] ), [GAP_YoY_Chg] )By using this measure in the matrix/chart you can easily change MoM to YoY etc.
_______________
If I helped, please accept the solution and give kudos! 😀