Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Group By Kind Local Help!

Hello Everyone, 

 

Someone recently helped me out in the community, I tried to replicate his solution and somehow I couldn't 😞

 

Sorry to bother, Can anyone help? 

 

https://wetransfer.com/downloads/2b6ed1ac150de5a0ce75d9237fc7dee620220413235025/3e2a9b 

Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi Anonymous ,

     

    You can follow the step on the right and check it one by one.

    Table:

    1 remove some columns and rows on the top and left.

    2 remove some columns is blank

    3 change the type of [RECURSO] to number and remove the result is null and error by Remove Rows.

    4 remove total column and select [RECURSO] and [DESC REC] then unpivot other colums.

     

    Table(2):

    1~2 same as Table.

    3 Use Group By function to group current table.

    4 Edit the code in the function bar:

    = Table.Group(#"Removed Top Rows1", {"RECURSO"}, {{"all", each _}}, GroupKind.Local,(x,y)=>Number.From(x[RECURSO]="" or y[RECURSO]=""))

    5 expend these table for each row via the icon on the top-right of the [all] field.

     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    4 years ago

    Hi Anonymous ,

     

    You can follow the step on the right and check it one by one.

    Table:

    1 remove some columns and rows on the top and left.

    2 remove some columns is blank

    3 change the type of [RECURSO] to number and remove the result is null and error by Remove Rows.

    4 remove total column and select [RECURSO] and [DESC REC] then unpivot other colums.

     

    Table(2):

    1~2 same as Table.

    3 Use Group By function to group current table.

    4 Edit the code in the function bar:

    = Table.Group(#"Removed Top Rows1", {"RECURSO"}, {{"all", each _}}, GroupKind.Local,(x,y)=>Number.From(x[RECURSO]="" or y[RECURSO]=""))

    5 expend these table for each row via the icon on the top-right of the [all] field.

     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi!

     

    Thanks for your replay. I tried what you mentioned in the query known as "Me doing it in XLS".

    I tried to replicate the solution as you mentioned before but sadly when I get to this step:

     

    = Table.Group(#"Removed Top Rows1", {"RECURSO"}, {{"all", each _}}, GroupKind.Local,(x,y)=>Number.From(x[RECURSO]="" or y[RECURSO]=""))

     

    Somebody help me please

     

    This is me trying to replicateWhat I should get

    • v-chenwuz-msft's avatar
      v-chenwuz-msft
      Community Support
      4 years ago

      Hi Anonymous ,

      Try this:

      Change the [RECURSO] type as text before group by.

       

      Best Regards

      Community Support Team _ chenwu zhu

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.