Forum Discussion
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:
Please help. Thanks a lot, Alex
Hi Alex, mark as a solution if resolve your problem.
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.
7 Replies
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
Hi Alex, mark as a solution if resolve your problem.
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
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.
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
The pbix is not accessible beacause is on your tenant.
updated link
example.pbix
