Skip to main content
cancel
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

Reply
Suhasini1
Frequent Visitor

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

Hi,

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

2 REPLIES 2
amitchandak
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 : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

 

Another Inventory Way Running total of open -closed

example


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" ))

 

 

Hi 

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

 

20230319_150521.jpg

20230319_150510.jpg

  • 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

Announcements
Europe Fabric Conference

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.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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