Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello all,
Would you be so kind and help me with one specific formula?
I need to calculate My Lease Liability C/F, Cumulated Interest and & Cumulated Deprecation.
Problem is that I have several hundred assets and they have all different stat date.
This is example is 7 months to Year-end but another might more or less.
Is there any solution in DAX how to sort this out?
My variables are given and highlighted in orange in this case.
Outcome should be figures in Red.
File password : 0000
https://ulozto.net/!vnIzk8wGuZPf/sample-xlsx
Thanks.
Andrej
Solved! Go to Solution.
You may research the code generated by Quick measure Running total.
You may research the code generated by Quick measure Running total.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |