Forum Discussion
Query editor - Sum of Distinct Count by column
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
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"
5 Replies
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
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.
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
