Forum Discussion
New table from based on existing (Sensor data and time data to average per hour).
It will be a 'Group By' on date and time with Average of the temperature. It's done via the interface on the 'Home' tab.
Hi Meinhardt
HotChilli has pointed out the correct direction. Here is a document for your reference: How to GROUP BY or summarize rows - Power Query As you already have Dato and Klokke (Time) columns in table Rum-Labratorie, you can duplicate or reference this table, then in the new table, group by Dato and Klokke (Time) columns to have the average of Temperatur in a new column.
In addition, it seems the current TidsTabel's Klokke (Time) column is probably not correct. I feel like creating it with below code will be better.
Time.StartOfHour([#"Klokke (minut)"])Best Regards,
Jing
Hi Meinhardt
HotChilli has pointed out the correct direction. Here is a document for your reference: How to GROUP BY or summarize rows - Power Query As you already have Dato and Klokke (Time) columns in table Rum-Labratorie, you can duplicate or reference this table, then in the new table, group by Dato and Klokke (Time) columns to have the average of Temperatur in a new column.
In addition, it seems the current TidsTabel's Klokke (Time) column is probably not correct. I feel like creating it with below code will be better.
Time.StartOfHour([#"Klokke (minut)"])
Best Regards,
Jing