Drill through using inactive relationship

Hi Nabil20_24 

You can perform following transformations to achieve this result.

1. Unpivot Active Date and Inactive Date
   
2. Extract Active/Inactive text from Attribute column to create another status column
   
   

    

3. Add a flag that would filter out the duplicate records. 
       Specifically, those who are inactive but have active date. So, we remove them and categorize it as inactive.

   Use custom column to create flag column

   

   Finally, filter out 0s and keep 1s to load the data.
   5. Pull 
   Month from Date – X-axis
   Count Client – Y axis

   Status2 – Legend
   Use slicer – Year (from date table), Month(From date table)
   Modelling-
   Active date--------Date[Date]
   Then you will get the desired result.
   For 2023

   

    

   For 2022

   

   Hope this helps!

   Attached file for your reference.