cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
romovaro
Post Patron
Post Patron

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
Post Patron
Post Patron

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
Post Patron
Post Patron

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors