The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello All,
I am trying to put together a data table for one of our managers in Power BI with the goal of having 1 line per Order. Data currently has mutliple lines. I can do the Group Rows function and get the Part Name and Qty into 1 cell, but it tend to come out looking like a blob ( AAA - 1BBB - 3CCC- 5) rather than seperating into even lines. The Part Names and Qty vary in length significantly so there is no formating that I have figured out. Any suggestions on how to get the Part Names on seperate lines in the same cell?
Current
Order# | Part Name | Qty |
111111 | AAA | 1 |
111111 | BBB | 3 |
111111 | CCC | 5 |
222222 | BBB | 4 |
222222 | AAA | 2 |
222222 | DDD | 1 |
222222 | FFF | 4 |
333333 | BBB | 1 |
333333 | AAA | 1 |
Ideal
Order# | Part Name - Qty |
111111 | AAA - 1 BBB - 3 CCC - 5 |
222222 | BBB - 4 AAA - 2 DDD - 1 FFF - 4 |
333333 | BBB - 1 AAA- 1 |
Solved! Go to Solution.
Hi, @TBaldwin11
You can try the following methods.
Column:
Part Name-Qty = [Part Name]&"-"&[Qty]
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @TBaldwin11
You can try the following methods.
Column:
Part Name-Qty = [Part Name]&"-"&[Qty]
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
77 | |
77 | |
36 | |
30 | |
28 |
User | Count |
---|---|
106 | |
97 | |
55 | |
49 | |
46 |