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

Thank you MFlelix for the help.

i been struggling for quite some days.

Have a wonderful day.

 

Thank you Harsh.