## Sum of a column

luca
Posts: 26
Joined: Sun Mar 03, 2019 6:08 am

### Sum of a column

Hi guys,

is possible to add a custom column with a formula which include a line reference to another column divided by the total value of a third column. So for example

A B Calculated column
1 2 1/10 (sum of B column)
2 5 2/10
4 3 4/10

thanks
Luca

PhilC
Posts: 274
Joined: Tue Sep 09, 2014 8:13 am

### Re: Sum of a column

Hi luca,

Do you need a calculated column? What will be your use of this calculation?

Have a read of Matt's post here: https://exceleratorbi.com.au/calculated ... sures-dax/

Work out if you really need a calculated column or if the solution can be made with measures.

Maybe provide some detail around the end measure required and a sample dataset with the data and expected solution (mock up in Excel) and someone should be able to help with the solution.

Cheers
Phil

Rudi
Posts: 16
Joined: Fri Sep 01, 2017 4:33 pm

### Re: Sum of a column

luca
Posts: 26
Joined: Sun Mar 03, 2019 6:08 am

### Re: Sum of a column

luca
Posts: 26
Joined: Sun Mar 03, 2019 6:08 am

### Re: Sum of a column

Rudi
Posts: 16
Joined: Fri Sep 01, 2017 4:33 pm

### Re: Sum of a column

You can create a new column based on the Total created by the Total Step.

eg:

= Table.AddColumn(#"Create Calc", "Total Value", each Total)

Rudi
Posts: 16
Joined: Fri Sep 01, 2017 4:33 pm

### Re: Sum of a column

I don't understand your second question?
Sorry!

luca
Posts: 26
Joined: Sun Mar 03, 2019 6:08 am

### Re: Sum of a column

Rudi
Posts: 16
Joined: Fri Sep 01, 2017 4:33 pm

### Re: Sum of a column

Return to “Power Query”

### Who is online

Users browsing this forum: No registered users and 0 guests