Forum Discussion
Solved
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 al...
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.
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.