Using The Extended Date Table - OFFSETS In Power BI

Опубликовано: 18 Июнь 2020
на канале: Enterprise DNA
9,967
112

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...


Смотрите видео Using The Extended Date Table - OFFSETS In Power BI онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал Enterprise DNA 18 Июнь 2020. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 9,967 раз и оно понравилось 112 посетителям.