Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Calendar Table for different regions

Greetings! I need to create an office attendance report ðŸ˜¢. In other words, I need to count the days the employees were in the office and compare them with the number of working days in the period...
Need Help
Show and Tell
Tips and Tricks
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    Hi Anonymous  You can handle this with a single calendar table by adding a Region column to differentiate cities and a Holiday column to mark holidays for each region. Use these columns to filter working days per city in your DAX measures. Relate the calendar to your attendance data and calculate WorkingDays by excluding holidays. 

V-yubandi-msft's avatar
V-yubandi-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi Anonymous ,

Thank you for being part of the Microsoft Fabric Community. The solution shared by Akash_Varuna  effectively aligns with your requirements.

Key concept:

Utilize a single calendar table enriched with

  1. A City or Region column to distinguish locations
  2. An IsHoliday flag to identify holidays for each city

This setup allows you to calculate working days dynamically for each city without duplicating tables, making your model clean, scalable, and easier to maintain.

Thank you Akash_Varuna for your response.

 

More details can be found in Microsoft documentation here: Design guidance for date tables in Power BI Desktop - Power BI | Microsoft Learn

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly