Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
5 years ago
Solved

Calendar Table

Hi all,   How do I create a DAX table which has the columns Year, Month and Working Days (in the month)?   Thanks
Data Protection
Need Help
Show and Tell
Tips and Tricks
  • Fowmy's avatar
    Fowmy
    5 years ago

    HenryJS 

    You can create a calendar table as follows:

    Calendar = 
ADDCOLUMNS(
    CALENDAR("01/01/2021", "31/12/2021"),
    "Year", YEAR([Date]),
    "Month", Month([Date]),
    "Working Day", WEEKDAY([Date],2) IN {1,2,3,4,5} 
)

     




MichielvS's avatar
MichielvS
Frequent Visitor
4 years ago

I have a report with tens of dates in it, in different tables. I cannot connect these (joined) tables to one calendar-table. Should I create tens of calendar-tables? That seems a bit too much of a good thing, doens't it? What is the best practise in this case?