Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Add up Total cell value into List using Mcode

Hi,     I create this List as below from my data source and hope to add 'Total' value in a row which will be for 5G + LTE_M. Then I could make below calculation for Total vs 5G or Total vs LTE_M....
General Comment
Need Help
Show and Tell
Tips and Tricks
  • danextian's avatar
    danextian
    1 year ago

    This is based on your original query

    let
Source = Table.Combine({#"TOSS service PO_master - Previous Backup Data", #"TOSS service PO_master - Current Weekly Data"}),
Frequency = Source[Frequency],
#"Removed Duplicates" = List.Distinct(Frequency),
#"Added Total row" = List.Combine({"Total"}, #"Removed Duplicates")
in
#"Added Total row"
Anonymous's avatar
Anonymous
Not applicable
1 year ago

+I've succeeded creating as below, just pls suggest if there is any better way. 

 

 

let
Source = Table.Combine({#"TOSS service PO_master - Previous Backup Data", #"TOSS service PO_master - Current Weekly Data"}),
Frequency = Source[Frequency],
#"Removed Duplicates" = List.Distinct(Frequency),
#"Converted to Table" = Table.FromList(#"Removed Duplicates", Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Added Custom" = Table.AddColumn(#"Converted to Table", "Custom", each "Total"),
#"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Added Custom", {}, "Attribute", "Value"),
#"Removed Duplicates1" = Table.Distinct(#"Unpivoted Columns", {"Value"}),
#"Removed Columns" = Table.RemoveColumns(#"Removed Duplicates1",{"Attribute"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Value", "Frequency"}})
in
#"Renamed Columns"

  • danextian's avatar
    danextian
    Super User
    1 year ago

    This is based on your original query

    let
Source = Table.Combine({#"TOSS service PO_master - Previous Backup Data", #"TOSS service PO_master - Current Weekly Data"}),
Frequency = Source[Frequency],
#"Removed Duplicates" = List.Distinct(Frequency),
#"Added Total row" = List.Combine({"Total"}, #"Removed Duplicates")
in
#"Added Total row"