Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Table.InsertRow - Sum one Column to cell

Hi, i got this table:     The last row is a step where i have used this code to create the the step.    #"Grouped Rows" = Table.Group(#"Changed Type", {"Source.Name"}, {{"Count", each Tabl...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    prova questa:

     

    #"Grouped Rows" = Table.Group(#"Changed Type", {"Source.Name"}, {{"Count", each Table.InsertRows(_,Table.RowCount(_),{[Source.Name="", Kontoart=39100, Stedsart="", #"Beskrivelse - Prognose"="Tekst", År=2020, Periode=1, Beløp=List.Sum([Belop])]})}}),

     

    Bonus task: quale riga della colonna Stedsart deve essere controllata?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

prova questa:

 

#"Grouped Rows" = Table.Group(#"Changed Type", {"Source.Name"}, {{"Count", each Table.InsertRows(_,Table.RowCount(_),{[Source.Name="", Kontoart=39100, Stedsart="", #"Beskrivelse - Prognose"="Tekst", År=2020, Periode=1, Beløp=List.Sum([Belop])]})}}),

 

Bonus task: quale riga della colonna Stedsart deve essere controllata?