Forum Discussion

iulian_buhat's avatar
iulian_buhat
Frequent Visitor
5 years ago
Solved

Need help generating a Dynamic Calendar Table

For a couple of reports I need a calendar table that generates all the dates from the day before the calculation to 6 months after. For now I have used the Calendar() dax command to do so, but when s...
  • amitchandak's avatar
    amitchandak
    5 years ago

    iulian_buhat , not very clear, you can create a calendar with dates like

     

    Date = calendar(Min(Table[Date]) , Eomonth( max(Table[Date])+180,0))
    Date = calendar(Min(Table[Date]) , Eomonth( today() + 180,0))

     

    you can create various combinations.

amitchandak's avatar
amitchandak
Super User
5 years ago

iulian_buhat , not very clear, you can create a calendar with dates like

 

Date = calendar(Min(Table[Date]) , Eomonth( max(Table[Date])+180,0))
Date = calendar(Min(Table[Date]) , Eomonth( today() + 180,0))

 

you can create various combinations.

iulian_buhat's avatar
iulian_buhat
Frequent Visitor
5 years ago

While not exactly what I was looking for, I did manage to create it like so 

Calender = ADDCOLUMNS (CALENDAR (Today()-1,Today()+180), "DayOfWeekNumber", WEEKDAY ( [Date] ))
 
I just needed it to move forwards and backwars right, guess you can add to it like integers
  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    iulian_buhat , yes, the days you can add as an integer. Eomonth we use move to the end of the month and we play around with value and do +1 to get the start of the month . Thanks for sharing what you have done.