Summarise Hourly Values

[Barrettone]

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.

[Barrettone]

@v-xiandat-msft Thank you for replying,

When I put that in, I am unable to choose [date].[day] from my date column. Is that because it is not a date heirarchy? 

DAX is this: 

Gas_Day_Sum = CALCULATE(

     SUM(Gas_Consumption[Reading (kWh)]),

     ALLEXCEPT(Gas_Consumption,Gas_Consumption[Date (Period Beginning)])

   )

Result is this:

[v-xiandat-msft]

Hi @Barrettone ,

You can try to create a Calculated columns.

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.

[v-xiandat-msft]

Hi @Barrettone ,

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.