Forum Discussion
jcastr02
Post Prodigy
Post Prodigygrouping by store
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...
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], ";")
olgad
Resident Rockstar
Resident RockstarHi,
in power query
= Table.Group(#"Changed Type", {"Store"}, {{"Temporary Support Reason", each Text.Combine([Temporary Support Reason], ";"), type nullable text}})