Forum Discussion
Solved
Help creating dynamic calendar table with future dates
I have created a dynamic calendar table:
Calendar Table = CALENDAR(Min('Rent'[Date]),Max('Rent[Date]))
My problem is that this report has dozens of tables with data updated by many people at different times during the month, some actual and some forecasts in the future, so I need a table with future dates in case other tables are updated before the 'Rent' table is updated. Is it possible to change Max('Rent'[Date] to increase the Max date by say twelve months (e.g. +12)?
pls thy this
Calendar Table = CALENDAR(Min('Rent'[Date]), EOMONTH(Max('Rent[Date]),12)
