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 Team,
Need help for the following.
ItemCode | Material |
1 | A |
1 | B |
1 | C |
How to transform the above data to following format.
1 | A B C |
Thanks in advance..
Solved! Go to Solution.
@Anonymous
Did you use the above formula as a MEASURE?
It works for me. Please see attached file
@Anonymous
You can use a MEASURE like
Measure = CONCATENATEX ( VALUES ( Table1[Material] ), [Material], " " )
Then put Item Code and above MEASURE in table visual
Thank you for the quick reply,but its not be the solution.Its just repeat the same value.
Thank you.
@Anonymous
Did you use the above formula as a MEASURE?
It works for me. Please see attached file
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 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |