Calendar intervals

[FZOU]

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 i'm facing a problem to add 5 years to my Starting date,this is my formula

DimDate = CALENDAR (FIRSTDATE(Sales[SalesCalendar]);DATEADD(Sales[SalesCalendar];5;YEAR))

My formula will not give me a single value for the LASTDATE,any one have an idea please ?

[amitchandak]

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