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 wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.