Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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


Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.