Filtering Multiple "Count of Date" Columns with One Slicer

[SirJJAnderson]

I followed the solution described in https://community.powerbi.com/t5/Desktop/Filter-Multiple-Date-Columns-in-One-Slicer/td-p/669410 to create a transformed data table and date table and create a relationship between them and my original data table.

However, my "count of date" columns are giving me incorrect numbers... they are counting dates that are outside of my date filter.

The "Count of createdate" column is returning a total of 53 for March - this is incorrect, should be 43.

The "Count of demo_date" column is also returning a total of 53 for March - this is correct.

The issue is that 10 deals with a demodate in March have a createdate before march. But I only want to count dates in March, regardless of the column. How do I do that? Don't want to count any dates in any column that are outside of my slicer 🙂

[v-lionel-msft]

Hi @SirJJAnderson ,

This is caused by the relationship between the tables, maybe you can add a filter on the "Earliest Createdate" column.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.