Forum Discussion

d4rren's avatar
d4rren
Frequent Visitor
6 years ago
Solved

Change from previous year

Hi guys,   I am relatively new to Power Bi, and I am trying to work out the change between previous year for a dataset with years from 2017 to 2041   ASGSCode SexKey AgeGroupKey ERPYear Number  ...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi d4rren 

     

    You can create a Column as below.

    Column = 
VAR __previousYear = 'Table'[ERPYear] - 1
VAR __previousYearNumber = 
CALCULATE(
    SUM( 'Table'[Number] ),
    ALLEXCEPT( 'Table', 'Table'[ASGSCode] ),
    'Table'[ERPYear] = __previousYear
)
RETURN 
IF( NOT ISBLANK( __previousYearNumber ), 'Table'[Number] - __previousYearNumber )

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi d4rren 

 

You can create a Column as below.

Column = 
VAR __previousYear = 'Table'[ERPYear] - 1
VAR __previousYearNumber = 
CALCULATE(
    SUM( 'Table'[Number] ),
    ALLEXCEPT( 'Table', 'Table'[ASGSCode] ),
    'Table'[ERPYear] = __previousYear
)
RETURN 
IF( NOT ISBLANK( __previousYearNumber ), 'Table'[Number] - __previousYearNumber )

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

  • d4rren's avatar
    d4rren
    Frequent Visitor
    6 years ago

    Mariusz this is exactly what I was after - so many ways of doing things in Power Bi!