Forum Discussion
RollUp Data per hour
The best way to handle dates and times is to create seperate date and time dimensions. You can transform your date time field via Power Query into seperate date and time fields.
Once in seperate fields I would create seperate date and time dimensions (tables). So you have a model that looks like this:
Once you have modeled the data correctly, you will be able to analyse the data by all aspects of time. By Hour, Minute, Time Parts eg. every 5 minutes etc...
I have created a sample workbook you can download here
You can also download copies of Date and Time dimension Power Query scripts here:
Power Query Date Dimension Script
Power Query TIme Dimension Script
The best way to handle dates and times is to create seperate date and time dimensions. You can transform your date time field via Power Query into seperate date and time fields.
Once in seperate fields I would create seperate date and time dimensions (tables). So you have a model that looks like this:
Once you have modeled the data correctly, you will be able to analyse the data by all aspects of time. By Hour, Minute, Time Parts eg. every 5 minutes etc...
I have created a sample workbook you can download here
You can also download copies of Date and Time dimension Power Query scripts here:
Power Query Date Dimension Script
Power Query TIme Dimension Script