DAX Calculations - Power BI Best Practices Vol. 3
9.4 هزار بار بازدید -
3 سال پیش
-
Take our Report Development Best
Take our Report Development Best Practices Checklist course: https://portal.enterprisedna.co/p/rep...
In this tutorial, I’d like to discuss my best practices for DAX Calculations. This is Volume 3 of a video series that discusses some of the best practices I’ve incorporated throughout the years of my Power BI learning journey. I’ve consumed many resources which have been instrumental but has quickly become overwhelming. So I made my own notes that are easy to digest and hopefully these will be useful to others.
Greg
Note:
Commenting section - 2nd bullet point should read: "If you have made assumptions in your code, you should also add explanatory comments"
**** Video Details ****
00:00 Introduction
02:05 DAX Editor Tips
03:42 Formatting
05:30 Commenting
06:11 Variables
07:19 Qualifications
07:55 CALCULATE
08:56 DATEADD
09:58 DIVIDE
10:35 SWITCH TRUE
11:27 Virtual Tables
12:52 USERELATIONSHIP
14:51 Measures / Calculated Columns
15:51 Measure branching
16:51 Context
18:03 Aggregation / Iteration
**** Related Links ****
Power BI Best Practices Vol. 1 - Data Modelling - Data Modelling - Power BI Best Practi...
Power BI Best Practices Vol. 2 - Data Loading and Transformation - Data Loading And Transformation - Pow...
Power BI Best Practices Vol. 4 - Reports & Visualization Pt. 1 - Reports & Visualizations Pt. 1 - Powe...
Power BI Best Practices Vol. 4 - Reports & Visualization Pt. 2 - Reports & Visualizations Pt. 2 - Powe...
Power BI Best Practices Vol. 5 - Top 10 - Top 10 Power BI Best Practices
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - http://enterprisedna.co/power-bi-reso...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...
#EnterpriseDNA #PowerBI #PowerBIBestPractices #PowerBIDesktop #PowerBITutorial #PowerBIDAX #DAX #DAXTutorial
In this tutorial, I’d like to discuss my best practices for DAX Calculations. This is Volume 3 of a video series that discusses some of the best practices I’ve incorporated throughout the years of my Power BI learning journey. I’ve consumed many resources which have been instrumental but has quickly become overwhelming. So I made my own notes that are easy to digest and hopefully these will be useful to others.
Greg
Note:
Commenting section - 2nd bullet point should read: "If you have made assumptions in your code, you should also add explanatory comments"
**** Video Details ****
00:00 Introduction
02:05 DAX Editor Tips
03:42 Formatting
05:30 Commenting
06:11 Variables
07:19 Qualifications
07:55 CALCULATE
08:56 DATEADD
09:58 DIVIDE
10:35 SWITCH TRUE
11:27 Virtual Tables
12:52 USERELATIONSHIP
14:51 Measures / Calculated Columns
15:51 Measure branching
16:51 Context
18:03 Aggregation / Iteration
**** Related Links ****
Power BI Best Practices Vol. 1 - Data Modelling - Data Modelling - Power BI Best Practi...
Power BI Best Practices Vol. 2 - Data Loading and Transformation - Data Loading And Transformation - Pow...
Power BI Best Practices Vol. 4 - Reports & Visualization Pt. 1 - Reports & Visualizations Pt. 1 - Powe...
Power BI Best Practices Vol. 4 - Reports & Visualization Pt. 2 - Reports & Visualizations Pt. 2 - Powe...
Power BI Best Practices Vol. 5 - Top 10 - Top 10 Power BI Best Practices
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - http://enterprisedna.co/power-bi-reso...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...
#EnterpriseDNA #PowerBI #PowerBIBestPractices #PowerBIDesktop #PowerBITutorial #PowerBIDAX #DAX #DAXTutorial
3 سال پیش
در تاریخ 1400/01/06 منتشر شده
است.
9,425
بـار بازدید شده