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],","))

     

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.