Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
NISHA_S
Resolver I
Resolver I

duplicate rows found in a table based on one column for different group

Hi , 

             Based on below data , i want to check whether any source (A) policy number  can be found in source (B)

for each date_run group .

 

Screenshot 2024-06-20 095748.png

I need an output like below. here main thing is last two rows for source B having duplicate policy number rows ,that one i did not included in duplicate because that policy number was repeated only  in source B not in B.

please help for solve this problem

Screenshot 2024-06-20 100515.png

1 REPLY 1
VahidDM
Super User
Super User

Hi @NISHA_S 

 

The last B rows are same but there is a similar row with source A which needs to change the dulp to Yes not No(Check this).

 

BTW, try this DAX to add a calculated column:

dupl = 
IF (
    MAXX (
        CALCULATETABLE (
            SUMMARIZE ( 'Table', 'Table'[policy], "CSD", DISTINCTCOUNT ( 'Table'[source] ) ),
            REMOVEFILTERS ( 'Table'[source], 'Table'[date_run] )
        ),
        [CSD]
    ) > 1,
    "Yes",
    "No"
)

 

output:

VahidDM_0-1718871533506.png

 

 

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

Appreciate your Kudos!! 

LinkedIn|Twitter|Blog |YouTube 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.