undefined

Hey Syndicate_Admin ,

please consider creating a pbix file that contains sample data, upload the pbix file to onedrive or dropbox and share the link, as the data you provided can not be pasted to a table in Power BI desktop.

Nevertheless, I would create some calculated columns

• the first contains only the date
• the 2nd only the hour of the time part
• the 3rd contains a check, that flags the rows where the date and the hour mark are the max value

Finally, create a measure that aggregates the values.

As I do not fully understand how you calculate the sample value 82.15, please describe how this value is calculated meaning describe the values that are used for the calculation.

Regards,

Tom