Forum Discussion
Best Practice For Displaying Date/Times in Local Time Zone
For Question 3 I would strongly recommend that you do not attempt to create that calendar table in Power Query or DAX. Instead create a Calendar table externally (in SQL Server, or a sharepoint file etc). This will save you a lot (a lot) of sanity.
Once you include business hours you also need to start thinking what to do when your users record activities outside of the standard hours. For example what should happen when someone starts working on Monday 6am or finishes on Saturday morning 10am etc. What should the granularity be? Is 10:15am different from 10:00 am etc,
If and when you have well defined rules for these cases you can then implement these rules in your DAX measures and create cross join tables with the required granularity.
Thanks for the advice lbendlin, sounds like I may be out of my depth with this one. Might have a poke around and see if I can find a a PBI consultant that might be able to do it for us 😉 Cheers