Forum Discussion

tmhalila's avatar
tmhalila
Icon for Resolver II rankResolver II
4 years ago
Solved

Date Table

Hello, Anyone assist please, I have created a Date Table and Marked it as a Date Table using CALENDARAUTO as screened below Calendarauto = VAR MinYr = YEAR(MIN(FactTablefile[Quarter_startdate]))...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    tmhalila , My advice would be to try like

     

    Calendar
    VAR MinYr = YEAR(MIN(FactTablefile[Quarter_startdate]))
    VAR MaxYr = YEAR(MAX(FactTablefile[Quarter_startdate]))
    Return
    calendar(date(MinYr,1,1), date(MaxYr,12,31))

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

tmhalila , My advice would be to try like

 

Calendar
VAR MinYr = YEAR(MIN(FactTablefile[Quarter_startdate]))
VAR MaxYr = YEAR(MAX(FactTablefile[Quarter_startdate]))
Return
calendar(date(MinYr,1,1), date(MaxYr,12,31))

  • tmhalila's avatar
    tmhalila
    Icon for Resolver II rankResolver II
    4 years ago

    Thank you amitchandak 

    I am glad to be part of this community, you saved my day👏👏👏. Stay blessed!