• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sum of numbers in Power query

Kamo

Member
Hello,

How to get the sum of the numbers with power query (see attached file)

Thanks in advance
 

Attachments

  • SumOfNumbers.xlsx
    11.2 KB · Views: 3
Code:
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"List", type text}}),
    GetSum = Table.AddColumn(#"Changed Type", "Sum", each List.Sum(List.Transform(Text.ToList([List]), each Number.From(_))))
in
    GetSum
 

Attachments

  • Copy of SumOfNumbers.xlsx
    19.2 KB · Views: 9
Back
Top