Query editor - Sum of Distinct Count by column

[skopcak]

Hello,
I have tables see the attachment, can I create a new column in the table that will contain the sum of the column number?

Text	number	RESULT: sum of column number
Text1	4,2	7,6
Text2	1,1	7,6
Text3	2,3	7,6

thank you answer

[vanessafvg]

@skopcak

split the colums then sum,  then concatenate the result but i think you might have to do some in DAX too

in power query split the columns into 2

create a calculated column that sums all in dax   (i.e CALCULATE(SUM(field1),ALL(table)) , (i.e CALCULATE(SUM(field2),ALL(table))

in dax join them back together  (concatenate)

might be better solutions out there

[MarcelBeug]

You can simply add a custom column with the formula below, in which "<PreviousStep>" is the name of the previous step in your query:

= List.Sum(<PreviousStep>[number])

Otherwise it looks to me like a DAX measure would be more appropriate.

[skopcak]

You should be able to suggest solutions in code?

CODE:

let
Zdroj = Excel.CurrentWorkbook(){[Name="Tabulka1"]}[Content],
#"Změněný typ" = Table.TransformColumnTypes(Zdroj,{{"Text", type text}, {"number", type number}, {"RESULT: sum of column number", type number}})
in
#"Změněný typ"

:CODE

thank you for answer

[MarcelBeug · Accepted solution]

Strange that you already have the column in your input table.

In the code below I just add a column with a slightly different name.

let
    Zdroj = Excel.CurrentWorkbook(){[Name="Tabulka1"]}[Content],
    #"Změněný typ" = Table.TransformColumnTypes(Zdroj,{{"Text", type text}, {"number", type number}, {"RESULT: sum of column number", type number}}),
    #"Added Custom" = Table.AddColumn(#"Změněný typ", "Sum of column number", each List.Sum(#"Změněný typ"[number]))
in
    #"Added Custom"

[skopcak]

Thank you very much, that's exactly what I needed.