Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I am working on a data model that contains transactions from 'n fuel tank, the type of transactions is litres issues, litres received and tank readings.
I am struggling to create a column that displays the tank level closing balance at the time of that transaction, it needs to be a rolling/culimative sum of the tank issues and receipts, but if there is a tank reading it needs to be the tank reading. I also need a second column that displays the value of the difference when a adjustment is made due to the tank reading.
Stock Movement = issues (-) or receipts (+)
Tank Reading = transaction that displays the actual tank level (auto of manual reading)
Expected Columns:
Adjustment = Difference between tank reading and previous tank C/B
Tank Level C/B = Tank C/B above plus adjustment plus stock movement
Please see example done in excel below, I need a power bi dax version:
What's the expected output? It looks like closing balance column only do the accumulation.
Proud to be a Super User!
Hi, please see below. I also updated the original post.
This is a excel version of what I need to create in power bi.
TANK C/B expected = F3+E3+D4, is this formula correct?
if you want to get column E result , you need to have column F value; if you want to get column F result, you need to hae column E value?
that's a circular reference.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
95 | |
80 | |
77 | |
66 |
User | Count |
---|---|
130 | |
106 | |
105 | |
86 | |
72 |