Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
2 years ago
Solved

grouping 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...
Need Help
  • jcastr02's avatar
    jcastr02
    2 years ago

    Hello olgad -  What option did you pick to group by here? All rows, etc.  did you manually change the formula?

  • olgad's avatar
    olgad
    2 years ago

    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's avatar
olgad
Resident Rockstar
2 years ago

Hi, 
in power query

 

= Table.Group(#"Changed Type", {"Store"}, {{"Temporary Support Reason", each Text.Combine([Temporary Support Reason], ";"), type nullable text}})

 



  • jcastr02's avatar
    jcastr02
    Post Prodigy
    2 years ago

    Hello olgad -  What option did you pick to group by here? All rows, etc.  did you manually change the formula?