DAX BASICS in Power BI Desktop [Part 2]

DAX Basics in Power BI Desktop [Part 2]/

In this tutorial, we will be learning about DAX basics in Power BI Desktop. We will go from creating a calendar table to creating an insightful Power BI report with all the measures created in the lesson.
If you are new to DAX, you might want to start with "DAX Basics in Power BI Desktop [Part 1]" Here is the link:    • DAX Basics in Power BI Desktop [Part 1]  

Please navigate through the content below:
0:37 Agenda
1:00 Create a basic calendar table
5:10 Create a relationship
6:50 Create a table to store measures
7:49 Aggregation functions
11:07 Evaluation contexts
12:05 The CALCULATE function
12:34 CALCULATE modifiers
16:43 Time intelligence functions
22:10 Create a Power BI report

Content Link: https://drive.google.com/file/d/1tD-U...
Data Source: The "financial" table is the sample dataset that is within Power BI Desktop.

___________
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: https://amzn.to/3ldPLpk
***DAX Patterns (Second Edition): https://amzn.to/3fBKdnD
***Analyzing Data with Power BI and Power Pivot for Excel: https://amzn.to/3fDPLOd
***Beginning DAX with Power BI: https://amzn.to/3fDEe1k
***Storytelling with Data: A Data Visualization Guide for Business Professionals: https://amzn.to/3mfPcwE
***Storytelling with Data: Let's Practice!: https://amzn.to/36c6Cot
***Information Dashboard Design: https://amzn.to/2V61o7h

___________Relevant PBI Topics
MEASURES vs CALCULATED COLUMNS in DAX:    • MEASURES vs CALCULATED COLUMNS in DAX  
How to Use the ALL DAX Function in Power BI:    • How to Use the ALL DAX Function in Power BI  
How to Use the Filter DAX Function in Power BI [The Basics]:    • How to Use the Filter DAX Function in Powe...  
How to Calculate PERCENTAGES in Power BI:    • How to Calculate PERCENTAGES Based on Colu...  
How to COMBINE Tables in Power BI:    • How to COMBINE Tables in Power BI  
____________

[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.

If you like the content, feel free to buy me a cup of coffee 😀👇https://www.paypal.me/vizxlization

If you don't want to miss anything, subscribe to our newsletter: https://vizxlization.com/welcome-to-v...

___________Please follow us on:
Web: https://www.vizxlization.com/
LinkedIn:   / vizxlization  
Twitter:   / vizxlization  
Facebook:   / vizxlization  
Instagram:   / nestoradrianzen  


Leave your comments and questions below!
Don't forget to subscribe!
Thanks so much!




#DAX #PowerBIDAX #PowerBItutorial #vizxlization