Using The Extended Date Table - OFFSETS In Power BI
Using the Extended Date table Offsets in custom Time Intelligence calculations, Slicers or Filters are something that you will learn in this video.
****For more Time Intelligence series, click the links below****
Create A Holiday Table In Power BI: • How To Create A Holiday Table In Powe...
M Function In Creating Extended Date Table: • How To Use M Function In Creating Ext...
Date Harvest Deep Dive - Power BI Time Intelligence: • Date Harvest Deep Dive - Power BI Tim...
Using The Extended Date Table - ISAFTERTODAY: • Using The Extended Date Table - ISAFT...
Setting Up A Dynamic Startdate And Enddate For Power Query Date Tables: • Setting Up A Dynamic Startdate And En...
Calculating Workdays Between Two Dates In Power BI: • Calculating Workdays Between Two Date...
**** Video Details ****
00:30 - Offset function mechanics
03:04 - Offset column example
05:34 - Offsets in DAX
10:00 - Offsets for specific weeks
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
FREE - Power BI Resources - https://enterprisedna.co/power-bi-res...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...
**** Related Links ****
Cumulative Totals Based On Monthly Average Results In Power BI - https://blog.enterprisedna.co/calcula...
Data Normalization in Power BI for Different Days Results - https://blog.enterprisedna.co/normali...
Build A Comprehensive Date Table In Power BI Really Fast - https://blog.enterprisedna.co/how-to-...
**** Related Course Modules ****
Time Intelligence Calculations - https://portal.enterprisedna.co/p/tim...
Power Query Series - https://portal.enterprisedna.co/p/pow...
Best Practices & Feature Reviews - https://portal.enterprisedna.co/p/bes...
**** Related Support Forum Posts ****
Fiscal Period Offset in Power Query - https://forum.enterprisedna.co/t/fisc...
Offset in CalendarTable - https://forum.enterprisedna.co/t/offs...
Period Slicer for custom Periods - https://forum.enterprisedna.co/t/peri...
For more offset support queries to review see here - https://forum.enterprisedna.co/search...
Watch video Using The Extended Date Table - OFFSETS In Power BI online, duration hours minute second in high quality that is uploaded to the channel Enterprise DNA 18 June 2020. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 9,967 times and liked it 112 visitors.
