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 ,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.