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

     




2 Replies

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

     




  • 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?