Forum Discussion
Dimitris_Kats
Helper V
Helper VAvoid Month filter in aggregation
Hello dear members. I have a manpower budget vs actual report and i have a problem when i am adding the aspect of time into my table. I have the total new hires by job position and I compare ...
johnt75
Super User
Super UserIt sounds like you really want the running totals to be displayed so that you're showing all the positions which have been budgeted for or filled up to the month in question. You could try something like
Total Budgeted =
var maxDate = MAX('Date'[Date])
return CALCULATE( SUM('Table'[Budgeted]), REMOVEFILTERS('Date'), 'Date'[Date] <= maxDate )
Total Actual =
var maxDate = MAX('Date'[Date])
return CALCULATE( SUM('Table'[Actual]), REMOVEFILTERS('Date'), 'Date'[Date] <= maxDate )
Total Remaining =
[Total Budgeted] - [Total Actual]
Dimitris_KatsHelper V
Helper VThank you very much johnt75 for replying to me.
Unfortunately I am getting wrong results for the actual hires. I am getting much more than I should.
What is the problem?
- johnt75
Is there prior year data for hires which is being included?
Can you show the relationships in your model as well as the results you are expecting and the results you are getting ?