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.
Can anyone give me any idea how to merge the data from the same customer on the same line? The Api brings the data in a very bad way, I did my best but still couldn't delete the null and keep the customer data on the table line.
Hi, @v-chenwuz-msft
Thanks for your solution, but I have several columns that make this solution impossible.
For example:
Hi @Anonymous ,
You can use Unpivot to do that.
Please refer the steps displaied by the gif.
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |