Accumulated Depreciation

[AndrejZitnay]

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

[v-chuncz-msft · Accepted solution]

@AndrejZitnay 

You may research the code generated by Quick measure Running total.