Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Create a table and chart for open and closed based on different conditions for past 5 months


Thanks in advance 


I have to create open and closed count based on different conditions (but not on status column) for past 5 months


Open condition: severity is critical or high and datecreated>5/1/2022 and dare created <10/31/2022 and automated close > 10/1/2022 


Got the counts like 

May 1

June 1

July 3

Aug 2

Sep 2

Oct 2 (so Oct count is 11)

Nov 18

Dec 16 ( based on  logic)


I need to populate this as a table 


Please give me some ideas

Super User
Super User

@Suhasini1 , What date you have, How do we know open and closed


One is HR Way

Power BI: HR Analytics - Employees as on Date :


Another Inventory Way Running total of open -closed


Active Employees = calculate(distinctCOUNT(EmpData[ID]) , filter(EmpData, EmpData[Hire Date] <= max(Date[Date]) && [Activity] = "Hire" ))
- calculate(distinctCOUNT(EmpData[ID]) , filter(EmpData, EmpData[Hire Date] <= max(Date[Date]) && [Activity] = "Termination" ))




Thank upu for your reply


I need to build this chart and table (below chart in screenshot) based on dates and count

Please find the attached open and closed queries in the screenshot.


Open logic is different and closed logic is different




  • Open logic is like count between the below  dates 

5/1/22 to 10/31/22 (should show as oct count)

5/1/22 to 11/30/2022  


  • Please suggest.



Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors