Forum Discussion

cosminc's avatar
cosminc
Post Partisan
7 years ago
Solved

Time Intelligence - YOY not working

Hi i use a calendar but with date = first date of each month (12 rows for each year) in relationship (Year-Month) with a  data base like this: Salesman   Sales    YM                      Date      ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi cosminc ,

     

    Please modify the formula as below:

    YOY =
VAR TY_sales =
    SUM ( Source[Sales] )
VAR LY_sales =
    CALCULATE (
        SUM ( Source[Sales] ),
        FILTER (
            ALLSELECTED ( Source ),
            Source[Year]
                = SELECTEDVALUE ( Source[Year] ) - 1
                && Source[MonthName] = SELECTEDVALUE ( Source[MonthName] )
        )
    )
RETURN
    DIVIDE ( TY_sales - LY_sales, LY_sales )

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi cosminc ,

 

Please modify the formula as below:

YOY =
VAR TY_sales =
    SUM ( Source[Sales] )
VAR LY_sales =
    CALCULATE (
        SUM ( Source[Sales] ),
        FILTER (
            ALLSELECTED ( Source ),
            Source[Year]
                = SELECTEDVALUE ( Source[Year] ) - 1
                && Source[MonthName] = SELECTEDVALUE ( Source[MonthName] )
        )
    )
RETURN
    DIVIDE ( TY_sales - LY_sales, LY_sales )

Best regards,

Yuliana Gu

  • cosminc's avatar
    cosminc
    Post Partisan
    7 years ago

    Thanks,

    it works.

    Cosmin