Hello, I have a case and I can't figure out how to deal with it.
I have 3 references tables :
1. "Calendar"
2. "list of employees" with their number
3. "list of projects" with their number
Our staff is rotating, and their wages are different each month.
I have then 2 facts tables :
1. "pay" with the wages every month
2. "planning" with the repartition of each employee into their respectiv projects.
planning is connected to the 3 references tables, but pay only to list of employee and calendar. Thus, when I try to dispatch the cost of wages it doesn't distributes wages to the projects. I can't figure out how to build a dax formula to get this... Could someone help me?
Thanks in advance
