Forum Discussion
Solved
Time Intelligence
Hi Group, A question on the Time Intelligence functions... I have a matrix visual, and one of the measures is a month on month change... That I can do, and it works, however the requirement is th...
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! 😀
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! 😀