Hi
Relatively new to PP.
I have two tables: Table 1 shows hours per employee per role per month over about 10 years.
Table 2 shows a single rate applicable to each year, and each year is different.
I have constructed a measure showing the hours for a particular role for each year:
Monthly Hours for Manager
I want to show the applicable yearly rate for each role, and am using:
However, this is simply aggregating the rates for each year (ie (0.2 + 0.25 + 0.3) = 0.75), rather than showing only the rate applicable for each year (ie 0.2, or 0.25, or 0.3, depending on the year).
Can I filter for each year in this Measure?
Am I not creating the relationship correctly possibly?
Any help greatly appreciated.
Cheers
pvr928
Relatively new to PP.
I have two tables: Table 1 shows hours per employee per role per month over about 10 years.
Table 2 shows a single rate applicable to each year, and each year is different.
I have constructed a measure showing the hours for a particular role for each year:
Monthly Hours for Manager
Code:
=sumx(CALCULATETABLE(FTEData,FTEData[Manager]),2000/12)
I want to show the applicable yearly rate for each role, and am using:
Code:
=sumx(Fringe,Fringe[FringeRate])
However, this is simply aggregating the rates for each year (ie (0.2 + 0.25 + 0.3) = 0.75), rather than showing only the rate applicable for each year (ie 0.2, or 0.25, or 0.3, depending on the year).
Can I filter for each year in this Measure?
Am I not creating the relationship correctly possibly?
Any help greatly appreciated.
Cheers
pvr928
Last edited: