Forum Discussion
Hourly Head Count Report
I am the manager of a fitness centre and I get my staff to count amount of members every hour 8am-9pm on Weekends and 6-10pm on Weekdays. I am wondering if Power BI would be beneficial to create reports for hourly averages for each day of the week. I currently have an excel file I use, but wondering if Power BI would be useful.
Thanks!
1 Reply
I should be. make sure you create a date field and a time field and join date with a calendar created in power BI. On-time create an hourly time bucket.
Refer :https://docs.microsoft.com/en-us/power-bi/guidance/
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s.
Refer
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
