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

     

amitchandak's avatar
amitchandak
Super User
6 years ago

use concatenatex

https://docs.microsoft.com/en-us/dax/concatenatex-function-dax

 

New Channel = concatenatex(table, channel)

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601