Forum Discussion
marnixrovers
8 years agoNew Member
Calculated value between to gas measurements
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?
- Anonymous8 years ago
marnixrovers,
Please check DAX in the attached PBIX file.
Regards,
Lydia
3 Replies
- AnonymousNot applicable
- marnixroversNew Member
Thanks a lot. Works like a charm!!!!
- AnonymousNot applicable
marnixrovers,
Glad to hear the issue is solved. You can accept my reply as answer to close this thread.
Regards.
Lydia