Finding duplicates dates across multiple columns by category

TJohnson6754 — Fri, 01 Dec 2023 19:47:07 GMT

Hi all,

I'm having trouble finding a way to find the consumers who have duplicate dates in multiple (2 in this case) columns.

Data collected and imported like this:

And I'd like to be able to identify the duplicate dates by consumer ID:

Here's a non-exhaustive list of things I've tried:

I separated the table into two - one for date column A and one for date column B, using SUMMARIZE COLUMNS and tried to match them from there but I kept getting errors. I matched the two tables on ConsumerID. They didn't like that. Then I tried one to many matching from the two ConsumerID columns to the parent table 'Consumers', and I still was getting all kinds of errors.

I *even* tried unioning the two tables and trying to manipulate the data from there:

I think this shows some serious gaps in fundamental knowledge on my part perhaps with row context vs. filter context, but I was hoping I could find a solution to this issue in addition to some suggestions for dax concepts to better familiarize myself with.

Thank you all!

Re: Finding duplicates dates across multiple columns by category

WinterMist — Fri, 01 Dec 2023 23:50:41 GMT

TJohnson6754

Still working on a more elegant way to do this, but here is a solution using a calculated column.

Regards,

Nathan

Re: Finding duplicates dates across multiple columns by category

TJohnson6754 — Mon, 04 Dec 2023 13:50:01 GMT

Thank you so much, this works perfectly!

topic Re: Finding duplicates dates across multiple columns by category in DAX Commands and Tips

Finding duplicates dates across multiple columns by category

Re: Finding duplicates dates across multiple columns by category

Re: Finding duplicates dates across multiple columns by category