How to sum by rows these data ?

[alex779]

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

Please help. Thanks a lot, Alex

[lucadelicio · Accepted solution]

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

[lucadelicio]

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

[alex779]

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.. 

---

@lucadelicio wrote:

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

---

[lucadelicio · Accepted solution]

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.

[lucadelicio · Accepted solution]

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

[lucadelicio]

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.

Let me know if i help you.

Mark it as a solution if resolve your problem!

Ciao

[lucadelicio]

The pbix is not accessible beacause is on your tenant.

[alex779]

updated link
example.pbix