Forum Discussion
RE: Summing Of Values From The Same Column In A Table
Hi Anonymous
You can replace #"Previous Step" in latimeria 's code with the last step name from Applied Steps pane of the query. For example, in the following image, the last step is "Added Custom2". It is added after its previous step "Removed Columns3". So you can find "Removed Columns3" in its step code in the formula bar. If you want to add a step after "Added Custom2", you can right click on "Added Custom2" and select Insert Step After option. Then paste below code in the formula bar to get the mean value in a new column.
Table.AddColumn(#"Added Custom2", "Custom", each List.Average(#"Added Custom2"[MFT COMBINED]))Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi latimeria ,
Thank you for taking your time out to reply to the issue that I am facing. However, because it is already a different day from the time that I posted that query, the code which you have suggested does not work for me as it no longer has previous steps available to go back to. However, I still appreciate the effort that you have put into the reply. If you happen to be able to suggest another coding for my issue, please do!
Yours sincerely,
Kaili.
Hi Anonymous
You can replace #"Previous Step" in latimeria 's code with the last step name from Applied Steps pane of the query. For example, in the following image, the last step is "Added Custom2". It is added after its previous step "Removed Columns3". So you can find "Removed Columns3" in its step code in the formula bar. If you want to add a step after "Added Custom2", you can right click on "Added Custom2" and select Insert Step After option. Then paste below code in the formula bar to get the mean value in a new column.
Table.AddColumn(#"Added Custom2", "Custom", each List.Average(#"Added Custom2"[MFT COMBINED]))
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.