If you want to know how to analyze your data by hour, minute, half hour etc in Power BI or Excel Power Pivot then I will show you how to build your own Time Table and how to round your data to the nearest minute More Info below

00:00 Intro
00:29 Explaining the data and goal
01:35 Splitting Date Time
02:10 Round to nearest minute using Modulo
04:08 Round to nearest minute using Column From Examples
05:48 Create a Time Table
10:48 Connect Fact table to Time Table and produce charts

Find a copy of the Time Table on our website
https://accessanalytic.com.au/freeex...


Video on Calendar Table
   • What is a Date Table / Calendar table...  

Follow me on LinkedIn
  / wynhopkins  

Twitter
  / wynhopkins  

Access Analytic Training
https://accessanalytic.com.au/training