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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
romovaro
Responsive Resident
Responsive Resident

Duplicates same column and check differences between status and other fields

 

 

Hello and happy Monday

 

I need help comparing duplicates (same number but one is normal project and the other one is integration) and check if they have differences regarding Status / Go live Risk Level and GLD.

 

romovaro_0-1687173199882.png

 

From the table below: CUID 1002187BE01 have no differences and for CUID DSYTDE03 have diff regarding Status/Risk and GLD

 

the formulas I found/have to identify differences are used for different tables:

 

IsDifferent Risk =
IF (
    COUNTROWS (
        FILTER (
            'Planview Daily Extract',
            'Planview Daily Extract'[CUID] = 'Baseline-PV Daily Extract'[CUID]
            && 'Planview Daily Extract'[Go live risk level] = 'Baseline-PV Daily Extract'[Go live risk level])
    ) + 0 > 0,
    "NO",
    "YES"
)

 

or different columns:

 

IsDifferent ICP Risk = IF ('Planview Daily Extract'[Go live risk level] <> 'Planview Daily Extract'[Go-live risk level (ICP)], "YES", "NO")
 
but I have issues with duplicates in the same column. Any help?
 
thanks
 
1 ACCEPTED SOLUTION
romovaro
Responsive Resident
Responsive Resident

I got the solution.

 

Thanks @amitchandak  (I used one of your solutions from another problem - Solved: Checking for different values in duplicates - Microsoft Fabric Community)

 

 

Risk Diff =
var _1 = countx(filter('PV Cel File','PV Cel File'[Integration CUID] = earlier('PV Cel File'[Integration CUID] )),'PV Cel File'[Integration CUID] )
var _2 = countx(filter('PV Cel File','PV Cel File'[Integration CUID]= earlier('PV Cel File'[Integration CUID]) && 'PV Cel File'[Go live risk level] = earlier('PV Cel File'[Go live risk level])),'PV Cel File'[Integration CUID])
return
if(_1 >1 && _1<> _2 ,1,0)
 
For other fields just replace Risk level.

View solution in original post

1 REPLY 1
romovaro
Responsive Resident
Responsive Resident

I got the solution.

 

Thanks @amitchandak  (I used one of your solutions from another problem - Solved: Checking for different values in duplicates - Microsoft Fabric Community)

 

 

Risk Diff =
var _1 = countx(filter('PV Cel File','PV Cel File'[Integration CUID] = earlier('PV Cel File'[Integration CUID] )),'PV Cel File'[Integration CUID] )
var _2 = countx(filter('PV Cel File','PV Cel File'[Integration CUID]= earlier('PV Cel File'[Integration CUID]) && 'PV Cel File'[Go live risk level] = earlier('PV Cel File'[Go live risk level])),'PV Cel File'[Integration CUID])
return
if(_1 >1 && _1<> _2 ,1,0)
 
For other fields just replace Risk level.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.