See attached PBIX file:
EDNA_Sample_rate_work_hours.pbix (255.9 KB)
This is a follow on question from links and resources posted by @BrianJ yesterday here: calculate-cumulative-wage-cost-with-changinge-rates/18711
How can I calculate cumulative cost of Pay in the model attached? I’m trying to avoid many-many relationship with the fact table Hours_Worked.
The rates Full-Time and Part-Time are not necessarily related by any ratio i.e I can’t rely on a factor to multiply to but rather must rely on lookup table.
Week 2 Accelerator course explains benefits/importance of star-schema vs snow-flake. I don’t understand how I should relate Rates (Full-time and Part-time) to Hours_Worked table.
Thanks for your help,