How to Create a Custom Date Table in Power BI (2024) | CALENDAR & CALENDARAUTO Functions
Learn Power BI in 2024
Aaj ka video dates table ke barey mein hone wala hai. Yeh video aapko pura date table banana sikhayega aur samjha bhi dega. Main aapko settings bhi bataunga is video mein taki aapko date table mein koi issue na aaye.
Dataset:
Link: https://github.com/aashiKT/lets_grow_...
File Name: datetablelearning.xlsx
In this video, we will cover:
Understanding and disabling the inbuilt Power BI date table
Creating a custom date table using the CALENDAR function
Enhancing the date table with ADDCOLUMNS
Using CALENDARAUTO for dynamic date ranges
Addressing issues with date hierarchies and sorting
Testing and updating the date table dynamically
This is the only tutorial you'll need for creating a date table in Power BI in 2024!
Timestamps:
0:00 Intro & Settings
1:43 Calendar Function
4:09 Adding Columns
11:56 Relationship
12:33 Mark as Date Table
12:56 Creating Hierarchy
13:51 Testing the Calendar Date
16:12 Sorting Date Table
17:44 CalendarAuto Function
18:39 Advance CalendarAuto Function
#PowerBI #CustomDateTable #PowerBITutorial #PowerBIDateTable #CALENDARFunction #CALENDARAUTOFunction #PowerBITips #DateTablePowerBI #PowerBIDateTableTutorial #PowerBI2024