Forum Discussion
Interactive table is needed
Just add a calculated column.
Column = DATE ( YEAR ( 'Table'[Date] ), MONTH ( 'Table'[Date] ), 1 )
Hello v-chuncz-msft ,
Many thanks for your help. I really appreciate that as this currently my very urgent project.
I will close another query as items are related as I need both tables and running deprecation and totals for March - 19
Here is my file. Password is still 0000
https://uloz.to/!2qnn9chBI2LN/cashflow-1-3-pbix
Now I just need last 3 things.
1st - Monthly count. 1st month should be zero, 2nd month should be 1, 3rd month should be 2nd etc.
(In this example Aug 18 - 0, Sep 18 - 1, Oct 18 - 2)
2nd - Cashflow should be Monthly payment but have to go from Month 1 as per above.
(In this example from Sep 18)
3rd - Interest. Start in Month 1. (PV*Rate)/12. (As per excel at top of this query)
4th - Lease. (Cashflow - Interest (As per excel at top of this query)
5th - Lease Liability. In month 0 it is PV and from month 1 Lease Liability - lease (As per excel at top of this query)
Sorry for so many requests but I struggle with this quick measures. I've tried deductions but it didn't worked for me.