Help creating dynamic calendar table with future dates

[Fusilier2]

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)?

[Ahmedx · Accepted solution]

pls thy this

Calendar Table = CALENDAR(Min('Rent'[Date]), EOMONTH(Max('Rent[Date]),12)

[Fusilier2]

Thank you very much for the VERY speedy response!