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 I'm trying to join or group by so that the information is grouped into the same record line. See below current vs. Desired result.
Current | DESIRED RESULT | |||
Store | Temporary Support Reason | Store | Temporary Support Reason | |
6244 | Internal Store Closure | 6244 | Internal Store Closure; Project ABC | |
6244 | Project ABC |
Solved! Go to Solution.
Hello @olgad - What option did you pick to group by here? All rows, etc. did you manually change the formula?
you can take any option max, min and then replace the part in the formula bar starting with each and before the type each Text.Combine([Temporary Support Reason], ";")
you can take any option max, min and then replace the part in the formula bar starting with each and before the type each Text.Combine([Temporary Support Reason], ";")
Hi,
in power query
= Table.Group(#"Changed Type", {"Store"}, {{"Temporary Support Reason", each Text.Combine([Temporary Support Reason], ";"), type nullable text}})
Hello @olgad - What option did you pick to group by here? All rows, etc. did you manually change the formula?