Need to Total sum of a column in each row

[Anonymous]

HI,

I need to Create a column which shows the total summation of the shown column using Power Query. For ex If the total of the attached column is 100, it should assign to all the rows

[camargos88]

Hi @Anonymous ,

Use this code for a custom column:

List.Sum(#"Changed Type"[Column1])

Change the bold part for your last step name.

[Anonymous]

Not Sure.. But it gives me error

[camargos88]

@Anonymous ,

What error are you getting ?

Please, show your m-code.

[Anonymous]

= Table.AddColumn(#"Changed Type5", "Custom", each List.Sum(#"Changed Type"[ROI For Bin]))

This is the error code.  I am a beginer in Power BI so do let me know if I am providing some wrong information.

[camargos88 · Accepted solution]

@Anonymous ,

Try this:

=Table.AddColumn(#"Changed Type5", "Custom", each List.Sum(#"Changed Type5"[ROI For Bin]))

Also, please if you get error again, code the error message.

[Anonymous]

It worked 🙂 thx a lot