Forum Discussion
Power Query M, the equivilent of SUM??
If you post the code from the advanced editor, I could probably clarify better. Below is a sample table from Excel PowerQuery. Step Source returns a table to which I want to add a column. I can reference source in a calculated column. I don't think it will appear as a drop down.
let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], CalcCol = Table.AddColumn(Source, "Custom", each [Column1]/List.Sum(Source[Column2])) in CalcColHope this helps,
Mike
Community ChampionCheck out this answer from imkeF
Hi serena11 ,
You might look at the post above from imkeF.
Nathaniel
would you be able to break that answer down n how it relates to my question please? I am not familiar with power query M formula so not able to understand it very well.
If you post the code from the advanced editor, I could probably clarify better. Below is a sample table from Excel PowerQuery. Step Source returns a table to which I want to add a column. I can reference source in a calculated column. I don't think it will appear as a drop down.
let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], CalcCol = Table.AddColumn(Source, "Custom", each [Column1]/List.Sum(Source[Column2])) in CalcColHope this helps,
Mike
Tom_YAdvocate II
Hi Mike,
Is there any way to do something similar, but write the answer back into "Column 1" instead of a new column "Custom"?
Thanks in advance.
