Forum Discussion

o59393's avatar
o59393
Post Prodigy
2 years ago
Solved

Group by gives error - Power Query

Hi all   I am doing a group by ID in Power Query with the following code:     = Table.Group( #"Changed Type", {"Id"}, { {"Title", each Text.Combine(List.Distinct([Title]),", ")}, {"Status", e...
Need Help
Show and Tell
  • OwenAuger's avatar
    OwenAuger
    2 years ago

    o59393 

    Your Grouped Rows1 step appears to be referring to the Changed Type step, which is not the immediately preceding step, which is presumably not as intended.

     

    Try changing the code of the step to:

    = Table.Group(
#"Expanded Region"
...

    Regards

  • danextian's avatar
    danextian
    2 years ago

    Hi o59393,

     

    Your Group By is referencing #"Changed Type" applied step. The merging and expanding came after that so [Region] still didn't exist before that thus the error. Replace it with #"Expanded Region"

     

     

OwenAuger's avatar
OwenAuger
Super User
2 years ago

o59393 

Your Grouped Rows1 step appears to be referring to the Changed Type step, which is not the immediately preceding step, which is presumably not as intended.

 

Try changing the code of the step to:

= Table.Group(
#"Expanded Region"
...

Regards