Forum Discussion
Anonymous
2 years agoNot applicable
Dynamically calculate employee count in column using previous month data
Hi Team, I need one help and will really appreciate your efforts to solve this!! I need to build one report as below , the ask is to calculate employee count for every month by using employee coun...
Anonymous
2 years agoNot applicable
Thanks ! Really appreaciate it !
It does render the result correctly but it's kind of lengthy one when the month year is increased till Dec 2029. Is there any way to do it dynamically using some iteration/recursion in M query or may be by using window fuction "Offset"