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