Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
I have a data set with HR Complaints, date opened and date closed.
I need to figure out how to calculate complaints managed during time period
For example, if a complaint was opened on January 1st and closed on March 15th, it was managed in January, February and March
If a complaint was opened in January and there is no closed date, then it was managed from January to September.
So I can then plot it over 12 months along with complaints opened and closed
For some reason, I do not understand how to get the managed #, can anyone help me?
Attached is a link to my power bi too
https://1drv.ms/u/s!Anb0OMw34A1iatPgFbh1MumNv0I?e=YZAYthSample Data.pbix
Hey @Unknowncharacte ,
this pattern is called "events in progress".
very powerfull from my point of view. I used it already.
Maybe you will catch the idea and handling behind this here:
https://www.daxpatterns.com/events-in-progress/
regards