How to create a Time Table to analyze your Power BI or Excel data

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/free-excel-stuff/free-excel-templates/


Video on Calendar Table
https://youtu.be/LfKm3ATibpE

Follow me on LinkedIn
https://www.linkedin.com/in/wynhopkins/

Twitter
https://twitter.com/wynhopkins

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