Year on Year change without using a date variable

[Catherinegrace]

Hi, 

I am trying to calculate the change of cashflows each year. In the table below, I have the Time step and value columns in the underlying spreadsheet used in my PBI dashboard. 

I would like to create a mesaure which outputs the change in values i.e. Time step 1 value less time step 0 value. 

I have used the following measure but it is not working as expected (please see screenshot of the table from PBI): 

Change in value =

    VAR __PREV_YEAR =

        CALCULATE(

            SUM('Data Set'[Value]),

            ('Data Set'[Time step] -1 )

        )

    RETURN

        SUM('Data Set'[Value]) - __PREV_YEAR

Any help would be greatly appreciated!

Katie 

[Jihwan_Kim]

Hi, @Catherinegrace 

Please try the below measure.

Change in value =
VAR __PREV_YEAR =
CALCULATE (
SUM ( 'Data Set'[Value] ),
FILTER (
ALL ( 'Data set' ),
'Data Set'[Time step]
= MAX ( 'Data set'[Time Step] ) - 1
)
)
RETURN
SUM ( 'Data Set'[Value] ) - __PREV_YEAR

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[Catherinegrace]

Hi Jihwan, 

Thanks for your reply. Unfortunately this is not working and gives: 

There is other data in my underlying excel but filtering on the correct parts should give the correct change in value. Please let me know if you have any other suggestions