Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Monthly variation

Good afternoon I would like to know how I can modify or create the measure to let me see the monthly variation with the previous month, currently I can see it this way but when making a filter of a different month it does not make the comparison, example if I select November 2022 and February 2022 I will not make the variation since it would not be the previous month I use these formulas:

1 Reply

  • Padycosmos's avatar
    Padycosmos
    Solution Sage
    3 years ago
    This is a calculation on an Year column. You may try using it for the month column with suitable modifications
    CY-PY% =
    var CY=sum('Table'[Applications])
    var PY= calculate(SUM('Table'[Applications]),FILTER(ALL('Table'),'Table'[Year]=MAX('Table'[Year])-1))
    var difference = CY-PY
    RETURN
    IF(PY<>0, DIVIDE(difference,PY),0)