cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## How to sum by rows these data ?

Hello There!
I am importing  energy values listed by days (column "Giorni") AND by "quarter of an hour columns" (96 columns = 4*24h/day) . I need to add a column next to day with the daily sum of all energy values for that day, i.e. sum the values by row for each 96 columns..
.
Is it at all possible in P.Bi or should I import data in a different way ?

Hope you can access my shared example.pbix file since I don't know how to send it:

example.pbix

2 ACCEPTED SOLUTIONS
Super User

Hi Alex, mark as a solution if resolve your problem.

Luca D'Elicio

Super User

Now don't use a calculated column to do this.
But use the automatic measure sum of Valore.
Create a table and put in Day and Sum of Valore.

Luca D'Elicio

7 REPLIES 7
Super User

Another faster way is to unpivot this table in the Power Query Editor.

And returns a table like this:
POD - Giorno - Quarter - Value

In this way you can sum faster all the value for a day with a measure like:

MEASURE =
SUM(Table[value])

Put in a visual table type the day and the measure and you'll have the result.

Mark as a solution if resolve your problem.

Ciao

Luca D'Elicio

Frequent Visitor

Thank you Luca. Actually it only partially solves my problem: it works fine as you suggested in a visual table but  I'd rather prefer to have it in a new column or new data table.
I tried this after unpivoting (thanks a lot!) on a new column called "Sum by day":

Sum by day = SUMX(FILTER(Table, Table[Giorno]="31/07/2022"),[Valore])

Unfortunately it only calculates on the indicated day but assign the result for each day which is weird..my foult I know.. no idea how to make SUMX recursive on all different days..

Another faster way is to unpivot this table in the Power Query Editor.

And returns a table like this:
POD - Giorno - Quarter - Value

In this way you can sum faster all the value for a day with a measure like:

MEASURE =
SUM(Table[value])

Put in a visual table type the day and the measure and you'll have the result.

Mark as a solution if resolve your problem.

Ciao

Super User

Now don't use a calculated column to do this.
But use the automatic measure sum of Valore.
Create a table and put in Day and Sum of Valore.

Luca D'Elicio

Super User

Hi Alex, mark as a solution if resolve your problem.

Luca D'Elicio

Super User

Hi Alex,

try to create a calculated column in wich you put a SUM.
ColonnaCalcolata =
SUM(Colonna1, Colonna2, Colonna n)
This column it will contain the sum of your column.

Mark it as a solution if resolve your problem!

Ciao

Luca D'Elicio

Super User

The pbix is not accessible beacause is on your tenant.

Luca D'Elicio

Frequent Visitor

example.pbix