Forum Discussion
Rolling measure missing values
Hi everyone! I searched through the forum and couldn't find the answer to my problem, so I hope you could help me. It's a very simple table that I have so I hope the solution is simple as wel...
Thanks a lot for your reply! However, my measure for number of leaving within three months of joining right now is:
Measure =
CALCULATE(CALCULATE([Sum_termination],DATESINPERIOD('Hire & Termination'[Entry_date],MAX('Hire & Termination'[Entry_date]),-3,MONTH)),DATESINPERIOD('Hire & Termination'[Report_date],MAX('Hire & Termination'[Report_date]),-3,MONTH))
because I don't calculate number of leavers for one month, but for 3 rolling months.
However, when I do that, the result that I get for categories above is not correct even if total number is correct. Do you have any idea what I need to change to get the expected values?