Discover why you need a 'Dates' table in your Power BI data model and how to create one if you want to build trends and use the built-in "Time-Intelligence" functions that are on offer in Power BI.
You can download the code for the dates table here:
effectivedashboards.com/course/qt9-why-you-need-a-dates-table-in-power-bi-and-how-to-create-one/
-------------------------
Free Resources
-------------------------
👉FREE (for a limited time) course on building a Power BI Work Order Backlog Analysis Dashboard
effectivedashboards.com/power-bi-quick-start-create-a-pbi-dashboard-in-90-minutes/
👉Access to the source PBIX files
effectivedashboards.com/courses/free-resources/
👉Article series on creating a maintenance management system data model and how to address the human factors of data collection for improved data quality. (This is not just relevant to maintenance and reliability data).
effectivedashboards.com/data-articles/
- QT#9 - Why You Need a 'Dates' Table in Power BI and How to Create One ( Download)
- How and Why you should mark a date table in Power BI ( Download)
- Date Tables in Power BI ( Download)
- Creating a Dynamic Date Table in Power BI ( Download)
- Date Harvest Deep Dive - Power BI Time Intelligence ( Download)
- How to create a date table in Power BI | Creating a date table in power BI | part 16 ( Download)
- Power BI Visual Guide #15 - The Slicer Pt1 - Using the Slicer With 3 Data Types and a Hierarchy ( Download)
- QT#47 - Adding a vertical current date line to a line chart ( Download)
- QT#11 - Adding a Line Graph with First and Last Data Points Highlighted in Power BI ( Download)
- Power Pivot Intro #1 - Data Model Date Dimension Table & Relationships ( Download)
- QT#19 - Drill Through From a Card Visual in Power BI - Option 2 ( Download)
- Power BI Visual Guide #4 - The KPI - 4 Different Ideas For Tracking KPI Goals or Limits ( Download)
- PowerBI Tutorial: Visualization & Graph Types by Categories ( Download)
- FenC Power BI les 1 oefenopdrachten Van data naar informatie ( Download)
- Get Started With Power BI in 2020 ( Download)
