Calculating Cumulative Totals Over Dates Using FILTER and EARLIER
Understand and apply the FILTER and EARLIER functions to create a cumulative total over a date column in Power BI, and explore an alternative approach using variables.
DAX Function
VAR Power BI DAX exercises.
These concepts all use VAR. Work through related PBIX exercises, compare the patterns, and submit numeric answers to save your progress.
5Related concepts
Concepts Using VAR
Calculating Win Ratio Using DAX Variables with Error Handling
Learn to calculate a ratio using DAX variables to improve readability and maintainability, while also implementing robust error handling for divide-by-zero scenarios.
DAX Exercise: Calculate Sales Ratio for Multi-Legged Animals using Variables and CALCULATE
Create a DAX measure using variables and CALCULATE to determine the ratio of sales for the current filter context to the sales of 4-legged and 6-legged animals combined within that same context, handling potential division by zero.
Optimizing DAX Formulas with Variables: Calculating Corrected Unsold Ticket Percentage
Learn to use DAX variables to break down complex calculations into logical, readable steps, specifically for calculating a corrected percentage of unsold tickets per artist.
Optimizing DAX Measures with Variables for Readability and Performance
Learn to use DAX variables to break down complex formulas into logical, readable steps, improving both maintainability and understanding of measures.