Forum Discussion
Interactive table is needed
Hello all,
Would you be so kind and help me with interactive table?
My Dashboard should contains interactive table, Lease Liability at beginning at 1st month & Lease Liability at 31.03.2019
I’ve added her links for data source and PBIX.
I have PV formula in PBI file.
Passwords are : 0000
https://ulozto.net/!UNAmkFEWfcJF/cashflow-xlsx
https://ulozto.net/!MI770rkrVenX/cashflow-pbix
Idea is that everything will change based on selection of Asset.
Problem is that sometimes is there Lease for 24 months, sometimes 36 months etc.
Can you help me out?
Many thanks.
Kind regards.
Andrej
4 Replies
You may take a look at the post below.
Hello v-chuncz-msft ,
Thanks for your help.
I've used bellow table. Problem is that There are all dates of my lease between start & end date.
I need to have one row per one month. In this case between Aug - 18 & Aug - 20.
With another asset will be range different.
Table =
VAR c =
CALENDARAUTO ()
RETURN
GENERATE (
'Full Lease List',
FILTER ( c, [Date] >= 'Full Lease List'[Start Date] && [Date] <= 'Full Lease List'[End Date] )
)
Any advice on that?
Here is link for PBI file. Password is 0000
https://ulozto.net/!iAMM9MEpOElD/cashflow-1-2-pbix
Once I will have table in correct order than I will need to find out way to calculate actual depreciation.
I must have in August month 0 and first deduction will be from September.
Many thanks for your kind help.Much appreciated.AndrejJust add a calculated column.
Column = DATE ( YEAR ( 'Table'[Date] ), MONTH ( 'Table'[Date] ), 1 )
