Forum Discussion

romovaro's avatar
romovaro
Responsive Resident
3 years ago
Solved

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.

 

 

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
 
Need Help
  • romovaro's avatar
    romovaro
    3 years ago

    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.

1 Reply

  • romovaro's avatar
    romovaro
    Responsive Resident
    3 years ago

    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.