Calculated value between to gas measurements

[marnixrovers]

I have a table with gas measurements from different gas meters. Just a flat table with three column:

1. Date/Time

2. GasMeter

3. GasMeasure

This table is filled with gas measurements, recorded each minute (with a risk of skipping minutes now and then) for various gas meters. I would like to calculate gas usage per row: basically the difference between a gas measurement f and the previous gas measurement for the same meter.

Does anybody now how to do that?

[v-yuezhe-msft]

@marnixrovers,

Glad to hear the issue is solved. You can accept my reply as answer to close this thread.

Regards.
Lydia

[v-yuezhe-msft · Accepted solution]

@marnixrovers,

Please check DAX in the attached PBIX file.



Regards,
Lydia

[marnixrovers]

Thanks a lot. Works like a charm!!!!