The most common table you'll work with in your BI Career is the date table you use across all of your reports... so you better make it flexible, scalable, and reusable. In this video, I'll walk you through a variety of basic Power Query transformations and even a little bit of M code to dynamically set the range of dates in your date table so that you'll be all set to visualize time-series data across thousands of Power BI projects.
- Building a Dynamic PARAMETERIZED Date Table in Power Query Editor ( Download)
- Setting Up A Dynamic Startdate And Enddate For Power Query Date Tables - Query Editor Tutorial ( Download)
- Create a date range parameter with Power query | Powerful Tricks to save your time in power query ( Download)
- DATE TABLE for Power BI using Power Query ( Download)
- Creating a Dynamic Date Query Table in Power BI - Query Editor Tutorial ( Download)
- Power Query Parameters - Dynamically Change the Output of Your Queries Depending on Their Value ( Download)
- Create Date Table with Dynamic Language in Power Query ( Download)
- Adding Parameter in Data Table M Function - Query Editor Tutorial ( Download)
- Creating a Dynamic Calendar Date Range in Power Query ( Download)
- How To Create a Date Table in Power Query | POWER BI | BI Tricks ( Download)
- Create A Parameter Table For Your Power Queries ( Download)
- Create Date Table or Calendar in Power Query M (Complete Guide) ( Download)
- How To Use Query Parameter In Power BI [2023 Update] ( Download)
- Excel Power Query Parameter from a Cell Value (using a Named Range or a Table) ( Download)
- Power Query - Faster & Easier Parameters ( Download)
