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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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