Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Summarise Hourly Values

I have hourly readings as below.  When I put them into a table in PowerBI it only gives the first figure from the day:   I need it to aggregate all 24 November 1 values into November 1...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

Below is my table:

The following DAX might work for you:

Measure1 = 
   CALCULATE(
     SUM('Table'[Reading]),
     ALLEXCEPT('Table','Table'[Date].[Day])
   )

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.