Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Merge rows where ID is the same

Hi all,

 

I have this table:

 

 


As you can see we have a duplicate in "CompanyID3". What I would like to achieve is to merge the 2 rows where "CompanyID3" = 13087, where the one with an ID in "CompanyID1" is the winner. Meaning - is there a duplicate in ID3, then the one with value in ID1 (if any) wins.

Is it possible?

 

Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    Please try to create this calculated column:

    Column = 
var id3 = 'Table'[Companies.CompanyID3]
var check = CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Companies.CompanyID3]=id3))
return
IF(check=2&&'Table'[Companies.CompanyID1]=BLANK(),0,1)

    Then apply it to the original table visual, the result shows:

    Hope this can help.

     

    Best Regards,

    Giotto Zhi

     

2 Replies