Measure containing only undefined values in Waterfall Graph (sample attached)

[gigi1]

Hi, 

I am trying to create a waterfall graph but I get stuck at calculating measures:

basically, for any of the 3 investments and of the different valuation dates (both dimensions included as filters), I would like to see in the graph the difference in the Revenue between the specified date and the previous date

For example, in the case of investment A, by selecting 31/3/2023 as the valuation date, I would like to see in the graph the difference between 130 and 90, therefore including 40 as the bar value in the waterfall.

However, I get the "chart only contains undefined values" error and I can't figure out the correct way to obtain the result I want - can anybody help me? (example attached)

Thanks a lot

[Lisa_P]

your expression is using the Above function which only works in tables

[gigi1]

Hi Lisa, what would be the workaround in my case? (I.e how can I calculate the difference between two values contained in different rows to be included in a graph?)

Thanks a lot