Forum Discussion

bideveloper555's avatar
bideveloper555
Icon for Helper IV rankHelper 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
Icon for Super User rankSuper 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
Icon for Helper IV rankHelper 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