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...
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: 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: 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
- 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 Calculate PERCENTAGES in Power BI: • How to Calculate PERCE...
- 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.
If you like the content, feel free to buy me a cup of coffee 😀👇www.paypal.me/vizxlization
If you don't want to miss anything, subscribe to our newsletter: vizxlization.com/welcome-to-v...
___________Please follow us on:
Web: 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
30 июл 2024