Forum Discussion
Alirezam
Helper V
Helper Vaggregation of rows
Hi dudes, I have tons of data in half-hour format and want to aggregate them to hourly format adding two half-hour data together for each hour. The excel sample is attached. Any idea how to do it...
Once you have the correct time on each row you just need a measure
Sum = SUM ( table[kWh] )
then you pull the Year, Month, Day and time from the table and add in the measure.
AlirezamHelper V
Helper VYes, but this was not my answer, may you please read again what I had asked? Thanks anyway
jdbuchanan71
Super User
Super UserOnce you have the correct time on each row you just need a measure
Sum = SUM ( table[kWh] )
then you pull the Year, Month, Day and time from the table and add in the measure.