Consolidate Issues Data for Last 3 Months with Status - DAX Help in Table

[Ramees_123]

Below I have given my Sample data. The table contains the details of issues with ID, Raised date, Closed date and Status.

Issue ID	Raised Date	Closed Date	Status
1	01-Jan-21	01-Feb-21	Closed
2	21-Jan-21	30-Jan-21	Closed
3	01-Feb-21		Open
4	20-Feb-21	20-Mar-21	Closed
5	01-Mar-21		Open
6	20-Mar-21	06-Apr-21	Closed
7	15-Apr-21		Open
8	06-Apr-21	15-Apr-21	Closed
9	10-May-21		Open
10	02-May-21		Open

I need to create a table visual to consolidate the data in the below format for last previous 3 months issues. Please help.

All Issues	Feb-21	Mar-21	Apr-21	Total
Issues Brought Forward	1	2	3	6
Issues Raised	2	2	2	6
Issues Closed	1	1	1	3
Issues Carried Forward	2	3	4	9

Issues Brought Forward - Issues create date on past months and closed date on this month or not yet closed.

Issues Raised - Issues create date on this month.

Closed Issues - Issues closed date on this month.

Issues Carried Forward - Issues Brought Forward + Issues Raised - Issues Closed

Total - Total of last three months counts.

[amitchandak · Accepted solution]

@Ramees_123 , I have a blog on similar lines for HR with start and end date. There you need a common date table to deal with it.

See if this can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

Also attaching the file, if that can help

[Ramees_123]

@amitchandak  Thanks a lot Amit 🙂 You saved my day.