Forum Discussion
How to sum by rows these data ?
- 3 years ago
Hi Alex, mark as a solution if resolve your problem.
- 3 years ago
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
- lucadelicio3 years agoImpactful Individual
Hi Alex, mark as a solution if resolve your problem.
- alex7793 years agoFrequent 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..
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
- lucadelicio3 years agoImpactful Individual
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.