Sum of a column

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

Sum of a column

Postby luca » Wed May 15, 2019 8:21 am

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

Postby PhilC » Wed May 15, 2019 9:04 am

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

Postby Rudi » Wed May 15, 2019 5:05 pm


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

Re: Sum of a column

Postby luca » Thu May 16, 2019 1:05 am


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

Re: Sum of a column

Postby luca » Thu May 16, 2019 1:15 am


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

Re: Sum of a column

Postby Rudi » Thu May 16, 2019 10:26 pm

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

Postby Rudi » Thu May 16, 2019 10:27 pm

I don't understand your second question?
Sorry!

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

Re: Sum of a column

Postby luca » Fri May 17, 2019 5:57 pm


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

Re: Sum of a column

Postby Rudi » Mon May 20, 2019 5:06 pm



Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 0 guests