Forum Discussion
Calculate Project Resources
Hi I’m having trouble caluclating total resource allocation per month I have a resoucre table that contains. Project Ref (unique project ID) Role (e.g. Project Manager) Required FTE = Resour...
Anonymous
You can have a calendar date. Can be something like :
Measure =calculate(sum([Required FTE], filter(calendar table, [date].[month]=max([date].[month])))
And please share a sample table for more accurate solution.
PaulZheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.