Forum Discussion

clarkey1988's avatar
clarkey1988
Icon for Helper II rankHelper II
4 years ago
Solved

Calculate Percentage Change from previous Year

Hi,   I wonder if anyone can help me. I have the below measure which is calculating the percentage change of "Suppliers" from current month from the previous month.   So in 2021 January had 154 s...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    4 years ago

    Hi clarkey1988 ,

     

    First create a calendar table,then create a relationship between the 2 tables.

    Create a measure as below:

    Measure =
VAR _previous =
    CALCULATE ( SUM ( 'Table'[Supplier] ), DATEADD ( 'Table'[date], -1, MONTH ) )
VAR _current =
    CALCULATE (
        SUM ( 'Table'[Supplier] ),
        FILTER ( 'Table', 'Table'[date] = MAX ( 'Table'[date] ) )
    )
RETURN
    IF (
        ISINSCOPE ( 'Table'[Month] ),
        SUM ( 'Table'[Supplier] ),
        FORMAT ( DIVIDE ( _current - _previous, _previous ), "percent" )
    )

    And you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Your formula looks a little complex.  Have you considered using SAMEPERIODLASTYEAR ()  or one of the Quick Measures?

 

I also don't see the column error you mention.