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

     




Fowmy's avatar
Fowmy
Super User
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} 
)