Forum Discussion
Creating Date Dim table: to show future 12 months
Hello-
I am trying to create a Date Dimension table that shows date for 12 months after the Max date in our data set. For example, last data point entered on 7/10/2020 and I want the date table to show dates up until 7/10/2021. Is that possible?
Thanks in advance!
Anonymous ,
Calendar =
Var _max = max(Table[Date])
return
calendar(min(Table[Date]) ,date(year(_max),month(_max)+12,Day(_max)))
if you need in the visual by selecting one date. You can modify to get next 12
2 Replies
- amitchandak
Super User
Anonymous ,
Calendar =
Var _max = max(Table[Date])
return
calendar(min(Table[Date]) ,date(year(_max),month(_max)+12,Day(_max)))
if you need in the visual by selecting one date. You can modify to get next 12
- edhans
Community Champion
Absolutely! Take a look at my Dynamic Date Table in Power Query. You just need to make your maximum date one year in the future by wrapping your maximum date in Date.AddYears([YourMaxDate],1)
