Forum Discussion

FZOU's avatar
FZOU
Helper IV
6 years ago

Calendar intervals

Hello,   I'm creating a DimDate in power bi desktop with dynamic intervals. For exp : FIRSTDATE=X ; LASTDATE=X+5 years To be more clear: FIRSTDATE=01/04/2020 ; LASTDATE=01/04/2025   In my case ...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

FZOU ,

try

DimDate = CALENDAR (FIRSTDATE(Sales[SalesCalendar]);date(year(FIRSTDATE(Sales[SalesCalendar]))+5,month(FIRSTDATE(Sales[SalesCalendar])),day(FIRSTDATE(Sales[SalesCalendar]))))

or

 

DimDate =
var _1 =FIRSTDATE(Sales[SalesCalendar])
return
CALENDAR (_1 ;date(year(_1 )+5,month(_1 ),day(_1 )))