Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
98 | |
90 | |
78 | |
71 | |
64 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |