How to Create a DATE/CALENDAR TABLE in Power BI/
In this tutorial, we will learn about how to insert a date table in Power BI. Also, we will create a relationship between a Date Table and another table in the model.
_______________
Highly recommended Power BI books: (Affiliate Links)
***The Definitive Guide to DAX: Business Intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel Second Edition: amzn.to/3ldPLpk
***DAX Patterns (Second Edition): amzn.to/3fBKdnD
***Analyzing Data with Power BI and Power Pivot for Excel: amzn.to/3fDPLOd
***Beginning DAX with Power BI: amzn.to/3fDEe1k
***Storytelling with Data: A Data Visualization Guide for Business Professionals: amzn.to/3mfPcwE
***Storytelling with Data: Let's Practice!: amzn.to/36c6Cot
***Information Dashboard Design: amzn.to/2V61o7h
_______________
Relevant PBI Topics
- DAX Basics in Power BI Desktop: • DAX Basics in Power BI...
- MEASURES vs CALCULATED COLUMNS in DAX: • MEASURES vs CALCULATED...
- How to Use the ALL DAX Function in Power BI: • How to Use the ALL DAX...
- How to Use the Filter DAX Function in Power BI [The Basics]: • How to Use the Filter ...
- How to COMBINE Tables in Power BI: • How to COMBINE Tables ...
____________
[DISCLAIMER]: Some links included in this description might be affiliate links. If you purchase a product with those links, I might receive a small commission. However, there is no additional charge to you! I appreciate your support and this will help me provide you with free content on a weekly basis.
Please navigate through the content below:
- Content: 0:26
- What is a date table?: 0:36
- Key characteristics of a date table: 1:17
- Uses of a date table: 2:38
- Types of date tables: 3:33
- How to create a calculated date table: 4:21
- Expand the date table: 14:19
- Create a relationship: 25:07
If you like the content, feel free to buy me a cup of coffee 😀👇www.paypal.me/vizxlization
Additional Columns Code:
"Year",YEAR([Date]),
"Month",FORMAT([Date],"MMMM"),
"Month Number", MONTH([Date]),
"Week Day", FORMAT([Date],"DDDD"),
"Week Day NUmber", WEEKDAY([Date]),
"Calendar Month",FORMAT([Date],"MMMM YY"),
"Month Year", FORMAT([Date],"YYYY MM"),
"End of Month",EOMONTH([Date],0),
"Report Date",FORMAT([Date],"YYYY/MM/DD")
Content Link: drive.google.com/file/d/1bYj-...
Other Sources:
- The Definitive Guide to DAX by Marco Russo and Alberto Ferrari
- Beginning DAX with Power BI by Philip Seamark
Please follow us on:
LinkedIn: / vizxlization
Facebook: / vizxlization
Instagram: / nestoradrianzen
Twitter: / vizxlization
LinkedIn: / vizxlization
Leave your comments and questions below!
Don't forget to subscribe!
Thanks so much!
#DateTable #CalendarTable #Vizxlization
Негізгі бет How to Create a DATE/CALENDAR TABLE in Power BI
Пікірлер: 51