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
accessanalytic.com.au/free-excel-stuff/free-excel-templates/
Video on Calendar Table
youtu.be/LfKm3ATibpE
Follow me on LinkedIn
linkedin.com/in/wynhopkins/
Twitter
twitter.com/wynhopkins
Access Analytic Training
accessanalytic.com.au/training
- How to create a Time Table to analyze your Power BI or Excel data ( Download)
- Working with time in Power BI Desktop ( Download)
- Time Table in Power BI ( Download)
- Do you need a date table for time intelligence in Power BI Nope! (Quick Measures) ( Download)
- Power Query | Calculating Hours Worked | Time Transformations | Microsoft Excel / Microsoft POWER BI ( Download)
- Creating a simple date table in Power BI ( Download)
- Script for Creating TIME Table in Power BI with Hours, Minutes and Seconds Buckets ( Download)
- Power BI Tutorial For Beginners | Create Your First Dashboard Now (Practice Files included) ( Download)
- Live Training Batches Details - Power BI with DAX ( Download)
- Create Time Dimension Power BI ( Download)
- Excel Data to Power BI - What's Still Working in 2024 ( Download)
- Time Series Chart in PowerBI | PowerBI Visualization | Line Chart ( Download)
- Create the ULTIMATE CALENDAR TABLE for your Power BI Reports // Beginners Guide to Power BI in 2022 ( Download)
- Excel to PowerPoint - Link Excel Charts Straight into PowerPoint ( Download)
- How to Build Power BI Reports from Start to Finish ( Download)
