DAX SERIES Part2 | How to Create DATE TABLE in Microsoft POWER BI | DATEDIFF? Practical Examples
In this video, we will show you how to create a DATE TABLE in Power BI using DAX functions.
In a Date Table, we would need the Date as a column, YEAR, QUARTER, MONTH, Week, Week Number, Month Number, Fiscal Year, Start of the Month, etc.
Watch this video for a step-by-step implementation of DATE TABLE.
FUNCTIONS explained in this video:
1️⃣ CALENDER()
2️⃣ CALENDERAUTO()
3️⃣ FORMAT()
4️⃣ YEAR()
5️⃣ QUARTER()
6️⃣ MONTH()
7️⃣ DATEDIFF()
8️⃣ STARTOFTHEMONTH()
9️⃣ ADDCOLUMNS()
First, I will show you the Power BI report that I have created to showcase all the functions used in PowerBI.
In my upcoming video, I will explain all these Function groups in depth.
You can expect one video for each Function Group.
⏱ VIDEO TOPICS:
===============
00:25 Understanding Master Tables
00:35 Getting Started with the DATE TABLE
08:18 How to define DATE TABLE in POWER BI?
09:00 How to build the relationship between the DATE Master and the Sales Master
10:30 Fact vs Dimension Tables (Star Schema)
12:00 Calculate the No. of Shipping Days (using DATEDIFF)
15:45 DATE & TIME Summary
📁 POWER BI LINK:
================
Power BI public Link
https://bit.ly/3WvBf0a
🟡RELATED VIDEO:
==================
▶ DAX Cheat Sheet | 8 Function Groups Explained in HINDI | Description + Syntax + Return Value | Part1 -- • DAX Cheat Sheet | 8 Function Groups E...
▶ DAX Series Part3 | FILTER Functions Explained in HINDI | Beginners to Advanced Level | Ms Power BI -- • DAX Series Part3 | FILTER Functions E...
💡 LEARN MORE
========================
▶ Power BI Playlist -- https://bit.ly/3U3NVts
▶ Data Analytics Projects -- https://bit.ly/3hb84zd
▶ Excel Training - https://bit.ly/3WvCUTs
💡 LET'S TALK
========================
☮Any specific query? Want to get an Interview ready? Ask me anything!
https://bit.ly/3DB03ex
#powerbitutorial #dax