Forum Discussion
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...
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
Community Support
Community SupportHi Anonymous ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.