L
Legacy 276829
Guest
Hi,
In an excel spreadsheet I can calculate for a list of person their respective time budget per month (s. picture).
Data Source:
Table Person
Table TimeBudget
Combination of both table:
calculate per person and month, the respective time budget (colored table part).
With both table I'm trying to make the same modell with PowerPivot.
What I would like is to calculate for each month of 2014, how much hour each person has to work (with respect to % occupation).
My issue is that both table (Person, Timebudget) can not be directly related. So I do not know where to begin with a measure in PowerPivot.
I have a calendar table in the modell as well.
Any idea if this can be do with a measure?
Regards,
Emmanuel
In an excel spreadsheet I can calculate for a list of person their respective time budget per month (s. picture).
Data Source:
Table Person
- Person
- % occupation
- Begin and End of occupation (the one with date 1/1/1900 are of course still occupied)
Table TimeBudget
- Month
- Hour per Month for 2014 (for 100% occupation)
Combination of both table:
calculate per person and month, the respective time budget (colored table part).
With both table I'm trying to make the same modell with PowerPivot.
What I would like is to calculate for each month of 2014, how much hour each person has to work (with respect to % occupation).
My issue is that both table (Person, Timebudget) can not be directly related. So I do not know where to begin with a measure in PowerPivot.
I have a calendar table in the modell as well.
Any idea if this can be do with a measure?
Regards,
Emmanuel
