Power BI DAX Practice
Each concept page explains the idea in plain English, gives you a downloadable Power BI starter file, then checks the result you produce after following the steps.
Understand and apply the DAX FILTER function to create virtual tables and modify filter context dynamically within measures, enabling complex aggregations based on related table conditions.
Learn to create simple DAX measures using SUM and DIVIDE for calculating vote proportions, and SUMX for summing expressions over a table to find vote differences.
Learn to create calculated columns that leverage implicit context transition for row-specific calculations and columns that override context to calculate global totals.
Create robust measures using CALCULATE to apply various filters and calculate conditional aggregations, such as percentages based on venue status, show cancellations, and ticket sales.
To calculate the required number of comfort breaks for each film based on its running time, by referencing a non-joined comfort breaks table using the EARLIER function to manage row context.
Learn how to use the SUMMARIZE function to group data and calculate aggregate measures such as average film length and total Oscars won per genre.