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...
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.
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.