Forum Discussion

wbadri's avatar
wbadri
Frequent Visitor
6 years ago
Solved

Combine multiple rows with condition

Hi,  I want to join two cell with same ID in one cell, the below shows the original data, I want to join channel column in one raw   Local Cell ID Equipment ID Sector ID Cabinet No. Subrack...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi wbadri 

     

    Please use the below measure:

     

    New Channel = CALCULATE(concatenatex('Table', 'Table'[Channel],","))

     

wbadri's avatar
wbadri
Frequent Visitor
6 years ago

Thank you very much,  I'm close to the answer, when I use the equation it depends on subrack no. where I want it to depend on local cell ID as differentiator:

 

 

 

  Thank you very much v-diye-msft 

 
 
v-diye-msft's avatar
v-diye-msft
Community Support
6 years ago

Hi wbadri 

 

Please use it as a measure not a calculated column. 

  • wbadri's avatar
    wbadri
    Frequent Visitor
    6 years ago

    Oh I can uderstand you, your solution worked perfectly, but can I edit the table in order to fix data and to remove dublicate rows that was from excel original excel sheet.