Power BI - Visual Calculations (Easy Mode for Writing DAX Formulas)
Learn how to create calculations that are independent of the semantic model, that are also easier to create and improve report performance.
File Download Link:
https://www.bcti.com//wp-content/YT_D...
00:08 What are Visual Calculations?
00:24 What can Visual Calculations work with?
00:43 Typical DAX Measure versus the same visual Calculation
01:15 Differences between DAX Measures and Visual Calculations
01:42 Visual Calculation Templates
01:55 Visual Calculation Interface
02:13 Formatting Calculation Results
02:35 File Download Instructions
02:50 Demonstration of Basic Visual Calculations
04:56 Editing existing Visual Calculations
05:07 Creating Matrix Calculations
05:19 "Versus Previous" Calculations
06:29 Calculating % of sales relative to all sales
07:04 Formatting the % results
07:34 Calculating % of sales relative to Department sales
08:32 Creating running totals
08:46 Running Total for entire matrix
09:15 Running Totals by Department
10:34 Running Totals by Year
11:19 Hiding repetitive subtotals and percentage totals
13:45 Hiding starting and ending results
15:01 Hiding the "False" change in the first month
16:16 Calculating ranks with RANKX
17:50 Removing the ranks for the parent-level items
18:37 Conclusion