Chapters:
0:00 Introduction
0:53 Importance of Calendar Tables
4:57 Create a Calendar Table using Worksheet Formulas (Dynamic Array Functions)
17:41 Create a Calendar Table using Power Query
26:04 Automatically Create a Calendar Table inside Power Pivot Window
30:16 Integrate Calendar Table inside Data Model
34:31 Close
---------------------------------------------------------------------
To watch the full Playlist
• PP: Power Pivot Tutorial
---------------------------------------------------------------------
To watch PQB: Power Query Basics Series:
• PQB :Power Query Basics
---------------------------------------------------------------------
To watch PT: Pivot Tables Series:
• Excel Data Analysis: P...
---------------------------------------------------------------------
To download the excel files:
drive.google.com/drive/folder...
---------------------------------------------------------------------
To subscribe:
/ @aaaexcel
---------------------------------------------------------------------
To follow on Facebook:
/ excelispower
---------------------------------------------------------------------
To follow on linkedIn:
/ amratef
Негізгі бет PP04: Power Pivot Tutorial - 3 ways to create CALENDAR TABLES, Why Calendar Table in a Data Model?
Пікірлер: 46