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 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 ?
Need Help

1 Reply

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