March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
how to derive different working hours per week for different locations?. We have global team of 1000 people and most of them have 40hours/week, but people in France have 35hours/week. I am using below dax to derive 8hours/day and 40hours/week. There is also a worklocation country column in my source sheet (below screen shot).
Solved! Go to Solution.
Create a separate country table which includes the number of hours per week and link that to your employee table in a many-to-one relationship. Then you can use
Work hours =
SUMX (
Utilization,
COUNTROWS (
FILTER (
'Calendar',
'Calendar'[Date] >= MAX ( Utilization[Hire Date], MIN ( 'Calendar'[Date] ) )
&& [Weekday] <= 5
)
)
* RELATED ( Country[Hours per week] )
)
Create a separate country table which includes the number of hours per week and link that to your employee table in a many-to-one relationship. Then you can use
Work hours =
SUMX (
Utilization,
COUNTROWS (
FILTER (
'Calendar',
'Calendar'[Date] >= MAX ( Utilization[Hire Date], MIN ( 'Calendar'[Date] ) )
&& [Weekday] <= 5
)
)
* RELATED ( Country[Hours per week] )
)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
94 | |
89 | |
86 | |
77 | |
49 |
User | Count |
---|---|
164 | |
149 | |
101 | |
73 | |
56 |