Forum Discussion

mmcdaniel's avatar
mmcdaniel
Regular Visitor
6 years ago

Calculate a Daily Population

I am very new to Power BI, so I will do my best to explain. I have a list of cases, which were assigned to staff members. For each case row, I have the staff name and the assigned and closed date. I am trying to calculate the total number of cases open on any given day. Is this possible? Here is a small version of what data I have:

Case NumberStart DateEnd DateStaff Assigned
560008/07/1908/16/19Staff A
560008/23/19NULLStaff B
56016/2/201912/6/2019Staff A
56027/5/201910/9/2019Staff C

 

Thanks!