Power BI DAX Masterclass - Measures & Calculated Columns

Explore how to create calculated columns and measures in Power BI, compare their physical versus virtual nature, and compute revenue from price and quantity.

Create a date table automatically with CALENDARAUTO, generating a contiguous date column based on your model's earliest and latest dates and illustrating the default fiscal year and month settings.

Build a Power BI date table with the calendar function, compare manual start/end dates to the auto calendar, and use minx with min/max for dynamic date ranges and features.

Create a drop-in DAX date table in Power BI, with year, month, month name, weekdays, and quarters, then connect it to the sales table for richer time analysis.

Organize your measures in a dedicated key measures table in Power BI, then explore basic aggregation functions and how to move and manage measures across tables.

Explore how aggregation functions power your measures in Power BI DAX, including creating a measure, calculating the average and the maximum of quantity, and visualizing results by customer or location.

Explore variations of Power BI dax aggregation functions, including count, count rows, count blank, distinct count, and count a, with blanks, booleans, and sample data to build robust measures.

Explore how the sumx function works by evaluating quantity times price at the row level, then summing results, and compare measures versus calculated columns to understand context in Power BI.

Learn how Power BI differs from Excel by using columns and tables instead of cells, and how measure context, filter context, row context, and the data model drive calculations.

Explore how filter context shapes Power BI measures by applying external filters and visualization context, then evaluate the data context and compute the measure.

Explore the row context in Power BI DAX, seeing how expressions are calculated per row with sum X before aggregation, and compare to a simple sum.

Learn how to use the calculate function to change the context of a revenue measure in Power BI, including same period last year and state filters like Utah.

Master the filter function within the calculate function to filter the location table by state (Utah), producing a filtered table of products with prices above a threshold.

Learn how the all function removes filters in a calculate context to compute a revenue percentage of the total, across states and products, even when other table filters apply.

Use the allselected function to ignore filters inside a visual while preserving external filters, ensuring revenue percentages always total 100%.

Explore allexcept in dax to control context, using the all and all except functions to show 100% proportions by tax rate or profit margin.

Learn to extend calculate-based filtering with logical operators (and, or, not) and functions like left, not, and not equal to refine revenue by price ranges and product name patterns.

Learn to create readable measures by applying multiple filters across products and location tables, then format with line breaks, indenting, and // comments to document logic for future review.

Explore the DAX values function to create distinct tables, such as weekdays or month-year lists, and apply it in an average X calculation to derive monthly and quarterly revenue averages.

Rank customers by quarterly average revenue with rankx, using all or calculate to fix year context and allselected to maintain continuity across filters.

Create a top-n filter in Power BI using a ranking measure on quarterly average revenue, with a top N filter table, if statements, and slicers.

Use variables in DAX measures to simplify complex expressions, improve readability, and reuse common calculations by defining them at the start and using return to compute the final result.

Explore time intelligence functions in Power BI using date add and calculate to shift date context for revenue measures and compare current vs prior periods.

compare total year to date and dates year to date in power bi dax, showing how the calculate function offers greater flexibility and handles multiple filters for accurate measures.

Explore how time intelligence functions, especially dates between, work with the calculate function to change context and create measures using a start and end date.

Explore the DAX query view in Power BI desktop. Run evaluate statements that return table results and use quick queries to explore data and assist measure creation.

Learn to use the DAX query view to explore data with evaluate and define, create and debug measures, and update the model with quick queries.