Forum Discussion
Measuring Store Hours with no Customers
Hi, I have created a matrix visual with hours (hour field) on rows and days of week (day field) on columns that measures customer traffic for a given hour and day. I noticed that some combination...
Seward12533
Solution Sage
Solution SageCan you share example of your dataset, measures and visuals?
If you just need a total should be easy to have a total number of hours and then subtract the hours with customers.
One way would be to use a date time table filtered by open hours and count rows see this thread for a discussion on how to build one to do that. https://community.powerbi.com/t5/Desktop/Efficient-Date-Time-Table-Creation-Using-DAX/td-p/466987 But there may be more elegant solutions.
If you just need a total should be easy to have a total number of hours and then subtract the hours with customers.
One way would be to use a date time table filtered by open hours and count rows see this thread for a discussion on how to build one to do that. https://community.powerbi.com/t5/Desktop/Efficient-Date-Time-Table-Creation-Using-DAX/td-p/466987 But there may be more elegant solutions.