RE: Summing Of Values From The Same Column In A Table

[Anonymous]

Dear all,

How can I add all of the values belonging in the, "MFT COMBINED" column before I find the mean value of it?

I would appreciate any assistance that is given.

[latimeria]

Hi @Anonymous ,

Is it what you are looking for?

Table.AddColumn(#"Changed Type", "Custom", each List.Average(#"Previous Step"[MFT COMBINED]))

[Anonymous]

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.

[v-jingzhang · Accepted solution]

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.