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

[Suhasini1]

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

[amitchandak]

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

[Suhasini1]

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

 

• 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.