Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
94 | |
87 | |
79 | |
76 | |
69 |
User | Count |
---|---|
116 | |
107 | |
88 | |
64 | |
63 |