Duplicates same column and check differences between status and other fields

[romovaro]

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.

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

@jgeddes 

[romovaro · Accepted solution]

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.