Forum Discussion

alex779's avatar
alex779
Frequent Visitor
3 years ago
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...
General Comment
Need Help
  • lucadelicio's avatar
    lucadelicio
    3 years ago

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

  • lucadelicio's avatar
    lucadelicio
    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.

     

lucadelicio's avatar
lucadelicio
Impactful Individual
3 years ago

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's avatar
lucadelicio
Impactful Individual
3 years ago

The pbix is not accessible beacause is on your tenant.