Forum Discussion

Creative_tree88's avatar
Creative_tree88
Icon for Helper V rankHelper V
2 years ago

Average Clients Per Hour, over a monthly timeframe

Hi all - trying to calculate the AVERAGE number of clients seen, per hour, over the course of a monthly timeframe (also yearly if possible).   I've attached a sample PBIX for you to help if possibl...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Turn on Date/Time intelligence and let Power BI create a 'date dimension' with Year and Month columns
Go to File menu/select Options and go to Current file/Data Load