Creating a Month overview based on multiple date columns

[Cfielding]

Hi Community

I have been scaling previous solutions/youtube etc but can't find anything that will work for what I'm trying to do. I have a dataset with 3 date columns pertaining to Received/Approved/Closed dates for various items, there are a number of blanks cells within each column. I am trying to display a count of items received, approved and closed for the month but any time I add in a slicer or try to filter it either won't work at all or will display the total number of approved/closed items based on the received items for that month, which I am assuming is down to the relationships to the date table.

The data set is effectivley like the below:

Item	Received	Approved	Closed
CHG1	01/02/2022	26/03/2022	30/05/2022
CHG2	23/02/2022	03/05/2022	06/08/2022
CHG3	23/02/2022
CHG4	03/04/2021	06/07/2021
CHG5	06/07/2022		10/07/2022
CHG6	26/07/2022	06/08/2022
CHG7	23/07/2022	06/08/2022
CHG8	06/03/2022

Ideally I want to be able to have one slicer that I can change to display the volumes across all cards. I currently have 3 separate date tables individually linked to a column and have tried a single date table that is linked to all the columns with Received being the active relationship. I'm quite new to PBI so anything you can suggest will be helpful.

[Cfielding]

@Greg_Deckler Thanks for that - I'd used the USERELATIONSHIP in an earlier test, but realise I was still telling it to use the Active relationship instead of the inactive one...

[Greg_Deckler · Accepted solution]

@Cfielding Using 3 separate date tables is a workable solution. If you use a single date table, then you will want to create the active and inactive relationships but use CALCULATE and USERELATIONSHIP to specify the correct relationship. Both of these methods are discussed in Mastering Power BI 2nd Edition.