Forum Discussion
Solved
Count duplicates (checking multiple columns) and displaying count in new column
Hello all I am working with data with duplicates; however, I can't remove them as I need to use other columns in other charts. I would ideally like to create the below - where the first three colum...
Hi, collis
You can try the following methods. Start by adding the index column to the Power query.
Count = CALCULATE ( COUNT ( 'Table'[Site] ), FILTER ( ALLEXCEPT ('Table','Table'[Scheduled Start],'Table'[Scheduled End],'Table'[Site]), [Index] <= EARLIER ( 'Table'[Index] ) ) )Is this the result you were expecting?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sorry - I just quickly put together a demonstration to help communicate (and keep the data private). Imagine they are duplicates.