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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

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
Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

Top Solution Authors