Forum Discussion

andybamber's avatar
andybamber
Icon for Helper III rankHelper III
6 years ago
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...
  • lkalawski's avatar
    lkalawski
    6 years ago

    andybamber 

    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! 😀