Forum Discussion
Staff Worked Hours Vs Rostered Hours
Hi LivioLanzo, I managed to simplify the dataset and work out the most difficult part for me - how to translate the Staff_Hours[Daily Hours] into the Time Slot Summary[Rostered Hours] by using of the following DAX code.
Rostered Hours = LOOKUPVALUE(Staff_Hours[Daily Hours], Staff_Hours[EmployeeID], 'Time Slot Summary'[EmployeeID], Staff_Hours[WeekDayNumber], 'Time Slot Summary'[WeekDayNumber]).
The rest should be pretty straight forward. Thanks again for offering to help, next time maybe.
Thank you offering to help LivioLanzo, unfortunately I cannot share the pbix file. If you offer still stands to help and my description is not clear please ask and I can try explain the situation bettter.
Thanks again.
Hi Landcrab
you have quite a few tables in your model and I would need to replicate them all manually in order to test something and at the end I could come up with a wrong measure / model because my replication was not correct
Hi LivioLanzo, I managed to simplify the dataset and work out the most difficult part for me - how to translate the Staff_Hours[Daily Hours] into the Time Slot Summary[Rostered Hours] by using of the following DAX code.
Rostered Hours = LOOKUPVALUE(Staff_Hours[Daily Hours], Staff_Hours[EmployeeID], 'Time Slot Summary'[EmployeeID], Staff_Hours[WeekDayNumber], 'Time Slot Summary'[WeekDayNumber]).
The rest should be pretty straight forward. Thanks again for offering to help, next time maybe.