Forum Discussion
Calculate backdated cumulative 'open' records
Hi all,
Seen a few similar posts about this but nothing that I've been apply directly or get my head around.
My table ('Logged') contains entries for indivudual records including colums for 'URN', 'Date Received' and 'Date Closed'
I need a measure that works out the number of open records at the end of each month so for every month this would calc:
Count rows if 'Date Received' before the filtered date AND either still open (i.e. ISBLANK('Date Closed')) or closed and 'Date Closed' is after filtered date.
Hope that makes sense!
On similar lines, Please refer my blog :https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
2 Replies
- amitchandakSuper User
On similar lines, Please refer my blog :https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
- AnonymousNot applicable
Have your solved the problem? If not could you provide a sample data, I am glad to help you out.
Best regards
Paul Zheng