Calendar Table

[HenryJS]

Hi all,

How do I create a DAX table which has the columns Year, Month and Working Days (in the month)?

Thanks

[MichielvS]

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?

[Fowmy · Accepted solution]

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