This is the second video in the series that we are doing on Time Intelligence. In this video, I covered the most important dimension table in any model, that is the Date Table.
***** Video Details *****
1:54 locate M Code Showcase in the forum
2:13 search Extended Date Table in the forum
2:50 enable Formula Bar
6:27 how to select and de-select column
7:55 DateTime.FixedLocalNow function
9:04 extract year only
10:25 get and invoke holiday list
*****For more Time Intelligence series, click the links below*****
Create A Holiday Table In Power BI - youtu.be/v9s0PPLU0n8
Date Harvest Deep Dive - youtu.be/mm-Lv6lv4a4
Extended Date Table: ISAFTERTODAY - youtu.be/PcHZLurLFv0
Setting Up A Dynamic Startdate And Enddate For Power Query Date Tables: youtu.be/iveCss_hzDo
Using The Extended Date Table - OFFSETS: youtu.be/Ieh0EhJzJgo
Calculate Workdays Between Two Dates: youtu.be/kRACuS4eKWA
***** Learning Power BI? *****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE - Power BI Resources - enterprisedna.co/power-bi-resources
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-download/
Learn more about Enterprise DNA - enterprisedna.co/
Enterprise DNA Membership - enterprisedna.co/membership
***** Related Links *****
Power BI Query Parameters: Optimizing Tables - blog.enterprisedna.co/optimizing-power-bi-tables-using-query-parameters/
Adding Workday And Weekend Numbers Into Your Date Table: Time Intelligence Technique In Power BI - blog.enterprisedna.co/placing-workday-and-weekend-day-numbers-into-the-date-table-in-power-bi/
Build A Comprehensive Date Table In Power BI Really Fast - blog.enterprisedna.co/how-to-create-a-detailed-date-table-in-power-bi-fast/
***** Related Course Modules *****
Ultimate Beginners Guide to Power BI - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
Time Intelligence Calculations - portal.enterprisedna.co/p/time-intelligence-calculations
Power Query Series - portal.enterprisedna.co/p/power-query-series
***** Related Support Forum Posts *****
Dynamic Date Table (Update Date Table) - forum.enterprisedna.co/t/dynamic-date-table-update-date-table/3715
Updating The Date Table - forum.enterprisedna.co/t/updating-the-date-table/6629
Multiple Date Table - forum.enterprisedna.co/t/multiple-date-table/8382
For more date table queries to review see here…. - forum.enterprisedna.co/search?q=holiday%20table
- How To Use M Function In Creating Extended Date Table In Power BI - Query Editor Tutorial ( Download)
- Introducing The Extended Date Table 2.0 - Power Query M Function ( Download)
- Extended Date Table Power Query M Function - Updated ( Download)
- Power Query (M) script to create a Date table in Power BI! ( Download)
- Dynamic Date Table Using the Power Query Editor ( Download)
- Setting Up A Dynamic Startdate And Enddate For Power Query Date Tables - Query Editor Tutorial ( Download)
- Adding Parameter in Data Table M Function - Query Editor Tutorial ( Download)
- How To Create a Date Table in Power Query | POWER BI | BI Tricks ( Download)
- DAshboard Creation - Part 1 ( Download)
- Using The Extended Date Table - ISAFTERTODAY ( Download)
- Changing Date Formats in Power BI | Power Query Editor Date Error ( Download)
- Creating a Dynamic Date Query Table in Power BI - Query Editor Tutorial ( Download)
- Convert The Date Table Function Into A Table Query in Power BI ( Download)
- What are Custom Functions in Power Query How to create it #powerbi #powerquery #biconsultingpro ( Download)
- Creating The Ultimate Date Table In Power BI - How To Do This Fast (Updated Code) ( Download)
