Forum Discussion
Helper I12 month rolling turnover
Hi Nabil20_24 , Hope the solution worked for you. can you please confirm this by marking it 'Accept as Solution', so others with similar queries may find it easily. If it didn't work, please share the details and we can work together to solve it.
Helper IThanks a lot for your helop,
Everything works fine except for the AverageEmployeesRolling12Months, which appears to be unaffected by the slicer. It consistently returns the value for December's AverageEmployeesRolling12Months across all months from January to December, regardless of the year selected in the slicer or the month displayed on the x-axis
Community SupportHi Nabil20_24 , Sorry to know it didn't work for you.
Can you please try these modified DAX formula:
AverageEmployeesRolling12Months =
VAR CurrentMonthEmployees = [CurrentEmployees] -- This gives the number of employees for the current month
VAR LastYearEmployees =
CALCULATE(
[CurrentEmployees],
SAMEPERIODLASTYEAR(DateTable[Date]) -- Getting the number of employees in the same month last year
)
RETURN
(CurrentMonthEmployees + LastYearEmployees) / 2
If this helps, please mark it 'Accept as Solution', if not please share the details, for us to better help you.
- Nabil20_24
still same problem
- v-hashadapu
Hi Nabil20_24 ,
Can you please go over the attached Pbix file and see if it helps solve the issue.If this helps, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details.
Thank you.