Forum Discussion
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....
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"
Hi Anonymous
Try this:
// Combine the text value "Total" with a distinct list of elements from the list "Frequency".
List.Combine(
{"Total"}, // A single-element list containing the text value "Total".
List.Distinct( // Remove duplicate elements from the list "Frequency".
Frequency // The list from which duplicates are removed.
)
)