Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 No. | Slot No. | Channel |
41191 | 0 | 0 | 0 | 70 | 0 | R0A |
41191 | 0 | 0 | 0 | 70 | 0 | R0B |
41191 | 0 | 0 | 0 | 70 | 0 | R0C |
41196 | 0 | 0 | 0 | 70 | 0 | R0A |
41196 | 0 | 0 | 0 | 70 | 0 | R0B |
41192 | 1 | 1 | 0 | 71 | 0 | R0A |
41192 | 1 | 1 | 0 | 71 | 0 | R0B |
50987 | 1 | 1 | 0 | 71 | 0 | R0A |
50987 | 1 | 1 | 0 | 71 | 0 | R0B |
50987 | 1 | 1 | 0 | 71 | 0 | R0C |
50987 | 1 | 1 | 0 | 71 | 0 | R0D |
This is the required results:
Local Cell ID | Equipment ID | Sector ID | Cabinet No. | Subrack No. | Slot No. | Channel |
41191 | 0 | 0 | 0 | 70 | 0 | R0A,R0B,R0C |
41196 | 0 | 0 | 0 | 70 | 0 | R0A,R0B |
41192 | 1 | 1 | 0 | 71 | 0 | R0A,R0B |
50987 | 1 | 1 | 0 | 71 | 0 | R0A,R0B,R0C,R0D |
How can i do this?
Thanks in advance
Solved! Go to Solution.
Hi @wbadri
Please use the below measure:
New Channel = CALCULATE(concatenatex('Table', 'Table'[Channel],","))
Hi @wbadri
Please use the below measure:
New Channel = CALCULATE(concatenatex('Table', 'Table'[Channel],","))
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
Hi @wbadri
Please use it as a measure not a calculated column.
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.
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-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |