Group after Appendig to tables

luis.marin

New member
Joined
Sep 27, 2016
Messages
2
Reaction score
0
Points
0
Location
Mexico
Hello Forum

This is my first post and is a help request!

Currently I use a query that appends two other queries(access db sourced), after appending I need it to be grouped by a column, the problem starts here because when I try to do this power query will just group by one of the tables(queries) and calculate the grouping in a "weird" form

The solution Im using now is to group first each query and the append each one, Im wondering if there is a way of doing this in one step

Thanks in advance
 
Hello

Ive seem to have found the solution!

My code was like:

let Origen = LPF,
#"Filas agrupadas" = Table.Group(Origen, {"CFRLPF"}, {{"SUMLPF", each List.Sum([IMPLPF]), type number}})
in
#"Filas agrupadas"

Looked into msdn and didnt understand at first but tested

let Origen = LPF,
#"Filas agrupadas" = Table.Group(Origen, {"CFRLPF"}, {{"SUMLPF", each List.Sum([IMPLPF], GroupKind.Local), type number}})
in
#"Filas agrupadas"

And got the problem solved, my grouping worked perfectly

Thanks in advance
 
Back
Top