PP04: Power Pivot Tutorial - 3 ways to create CALENDAR TABLES, Why Calendar Table in a Data Model?

Опубликовано: 22 Апрель 2026
на канале: AAA Excel’s Power

19,991

381

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: PT - Pivot Tables
---------------------------------------------------------------------
To download the excel files:
https://drive.google.com/drive/folder...
---------------------------------------------------------------------
To subscribe:
   / @aaaexcel
---------------------------------------------------------------------
To follow on Facebook:
  / excelispower
---------------------------------------------------------------------
To follow on linkedIn:
  / amratef