Forum Discussion

bideveloper555's avatar
bideveloper555
Helper IV
5 years ago
Solved

YOY on card

hi i want to exlcude records from YOY measure if there is no value for current year/month based on user slicer selection.   I did write a measure,which was working as it supposed to but requiremen...
Need Help
Tips and Tricks
  • MFelix's avatar
    MFelix
    5 years ago

    Hi bideveloper555 ,

     

    Create the following measures:

     

    Previous year = 
SUMX (
    VALUES ( 'Table'[Id] ),
    IF (
        ISBLANK ( SUM ( 'Table'[ Current YEAr ] ) ),
        BLANK (),
        CALCULATE (
            SUM ( 'Table'[ Current YEAr ] ),
            SAMEPERIODLASTYEAR ( 'Date'[Date] )
        )
    )
)


YOY % = DIVIDE([Previous year] - SUM('Table'[ Current YEAr ]) ,[Previous year])

     

    Now you can use on a table or a card:

     

    Believe that on your image some calculationa are not exactly at line level, but the syntax should be similar to the ones above.

     

     

MFelix's avatar
MFelix
Super User
5 years ago

Hi bideveloper555 ,

 

Create the following measures:

 

Previous year = 
SUMX (
    VALUES ( 'Table'[Id] ),
    IF (
        ISBLANK ( SUM ( 'Table'[ Current YEAr ] ) ),
        BLANK (),
        CALCULATE (
            SUM ( 'Table'[ Current YEAr ] ),
            SAMEPERIODLASTYEAR ( 'Date'[Date] )
        )
    )
)


YOY % = DIVIDE([Previous year] - SUM('Table'[ Current YEAr ]) ,[Previous year])

 

Now you can use on a table or a card:

 

Believe that on your image some calculationa are not exactly at line level, but the syntax should be similar to the ones above.

 

 

  • bideveloper555's avatar
    bideveloper555
    Helper IV
    5 years ago

    Thank you MFlelix for the help.

    i been struggling for quite some days.

    Have a wonderful day.

     

    Thank you Harsh.

  • bideveloper555's avatar
    bideveloper555
    Helper IV
    5 years ago

    hi

    on same data set, am trying to calculate 3 months growth,6 months growth.

    Logic,

    Only records should be included in 3 months growth.

    user selects 2020 mar

    but some stores might not have sales in jan but have in feb,mar 2020. these should be exlcuded.

    only stores who has consective 3 months should be calculated. jan,feb, mar 2020