Count based on Current quarter and Next Quarter

[Junaid11]

Hello,
I have thre columns as shown in table below. I want to count the status column. Open status should be done based on due date column while closed status should be done on closed date column. I want to count the open and close for current quarter and next quarter which will come after this quarter. 

Status	Due Date	Closed Date
Open	23/2/2023	12/1/2023
Close	11/2/2023	3/1/2023
Open	12/4/2023	18/3/2023
Close	20/6/2023	2/6/2023
Open	19/1/2023	4/1/2023
Open	25/6/2023	5/5/2023
Close	7/9/2023	27/8/23
Open	17/9/2023	17/9/2023

It should not count next quarter for all the next coming quarter but for the single next quarter. My outcome will look like below as per above data. 

Status	Current Quarter	Next Quarter
Open	2	2
Close	1	2

Your help would be highly appreciated.
Thank you

[Rudy_D]

Hey !

Please try this 🙂 :

Current Quarter = QUARTER(TODAY())

Quarter Due Date = QUARTER(SELECTEDVALUE(Table[Due Date]))

Quarter Close Date = QUARTER(SELECTEDVALUE(Table[Close Date]))

Current Quarter Count =

CALCULATE(COUNT(Table[Status]), FILTER(Table, (Table[Status] = "Open" && [Quarter Due Date] = [Current Quarter]) || (Table[Status] = "Close" && [Quarter Close Date] = [Current Quarter]) ))

Next Quarter Count =

CALCULATE(COUNT(Table[Status]), FILTER(Table, (Table[Status] = "Open" && [Quarter Due Date] = [Current Quarter] + 1) || (Table[Status] = "Close" && [Quarter Close Date] = [Current Quarter] + 1) ))

Please find below the result for the current quarter count :).

[Junaid11]

Helo @Rudy_D ,
Can you provide the file as I am applying same measures but getting blank. Can you provide the file please?

[Rudy_D]

Please find my test file here :

Test 

[Junaid11]

Hello @Rudy_D ,
I checked but next quarter formula is not getting the correct outcome. 

[Rudy_D]

I don't understand you expectation. 
Which are the 2 "close" that you expect for the next quarter ? For me there's only one in your table.