Forum Discussion

twofingertyper's avatar
twofingertyper
Icon for Helper III rankHelper III
1 year ago
Solved

Two tables, differing data - merge, append new or other?

Hi all,  I have two tables - one that runs for a longer period (AllSales) and one that is shorter, but captures cancelled sales (SalesStatus).  They do not have identical columns, but both have a...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago
    let
    Source = #"All Sales" & #"Sales Status",
    #"Grouped Rows" = Table.Group(Source, {"SalesOwnerID", "Date", "Status", "ProductID", "UniqueID"}, {{"Value", each List.Sum([Value]), type nullable number}})
in
    #"Grouped Rows"

     

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago
let
    Source = #"All Sales" & #"Sales Status",
    #"Grouped Rows" = Table.Group(Source, {"SalesOwnerID", "Date", "Status", "ProductID", "UniqueID"}, {{"Value", each List.Sum([Value]), type nullable number}})
in
    #"Grouped Rows"

 

 

twofingertyper's avatar
twofingertyper
Icon for Helper III rankHelper III
1 year ago

Thanks - that works, I did wonder about the impact of grouping larger data chunks, but this will work for now I think.