5 DAX Tips that You Should Know [Power BI 2021]
5 DAX Tips that You Should Know [Power BI 2021]//
In this lesson, I'll show you 5 DAX tips that every Power BI developer should know.
0:43 What's DAX?
1:23 Reduce number of calculated columns
2:55 Use variables
3:52 Use the DIVIDE function to perform a division
5:28 Format your DAX code
6:52 Your model should have a calendar table
8:32 Case
Content Link: https://drive.google.com/file/d/1eEzs...
___________Highly recommended Power BI books (Affiliate links):
***Collect, Combine, and Transform Data Using Power Query in Excel and Power BI:
https://amzn.to/2SEDXno
***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!
#DAXTips #PowerBI #vizxlization #PowerBIDAX