DAX Pro: Advanced Skills for Power BI Users

Segment customers in Power BI by building a secondary table of profit ranges and a dynamic measure to classify each customer into top, mid, and worst groups, per quarter.

Detect anomalies quickly in Power BI using a sequence of dex measures, leverage the data model, and explore why they occur with time intelligence and filters.

Master cluster analysis in Power BI by using DAX measures, calculated columns, and a supporting table to form profit-based groups shown on a scatter chart of profit margins and sales.

Explore advanced outlier detection in Power BI using DAX, building threshold tables, classifying customers as outliers or non-outliers, and creating dynamic, drillable visuals for deep insight.

Explore cross-selling opportunities with basket analysis by configuring a duplicated products table, using an inactive relationship, and applying DAX calculations to reveal which products pair most often in Power BI.

Explore pattern recognition in Power BI by using frequency of transactions to uncover how purchase activity impacts sales growth and profit margins, illustrated with scatter charts and custom DAX measures.

Explore threshold triggers in Power BI using DAX to identify customers who pass multiple thresholds—sales, transactions, and margins—across time frames, with a dynamic memory-based evaluation.

Explore secondary table logic to dynamically evaluate transactions over the last 60 days and classify salespeople into groups using a reusable, relationship-free approach.

Apply the 80/20 Pareto rule to Power BI data by testing how the top 20% of customers contribute to total sales across regions, using ranking and filtering techniques.

Explore customer attrition patterns using DAX in Power BI, classifying daily sales into new, returning, and lost customers and walking through the underlying logic and formulas.

Build dynamic ranked lists in Power BI to identify top salespeople by store, region, and timeframe, using calculate logic, ranking, and the values function across any dimension.

Leverage the calculate function to change context, apply filter context and time intelligence, and build cumulative sales, last year analyses, and dynamic grouping techniques in Power BI.

Master calculate table to change the context of a table and use variables for readable dax formulas, while integrating virtual tables and dax clean up tools for advanced analytics.

Explore that DAX variables are not global and are evaluated within the initial context. See how virtual tables support ranking top 50 customers by orders for deeper Power BI insights.

Apply DAX techniques to build virtual tables with filter and count rows, then analyze top 50 customers' orders and their share of total sales.

Create a virtual top customers table with calculate table, rank by revenue, and filter the sales data to the top 50 (or 250) to count their sales in Power BI.

Learn to use the deck cleanup tool and the analyst hub to save and share formula patterns, copy formulas from the community into Power BI reports, and speed up development.

Explore iterating functions in Power BI using x-ending functions to evaluate row-level logic over virtual tables, with variables, related pricing, and calculate context for fast analysis.

Unify the y axis across six visuals showing revenues and gross profit by business line and date, using a slicer to switch between automatic and unified scales for clearer comparisons.

Explore using field parameters and a switch-based approach to maintain consistent sorting in small multiples, implement a single slicer for two field parameters, and align y-axis lines across charts.

Configure line charts with min, average, and max constants using field parameters and slicers. Improve table visuals with hierarchical titles, alignment, padding, spacing, and styling for gross margin.

Reformat tables to a single row-based layout for side-by-side revenues, gross margins, and gross margin percentage, and refine charts with top-five tiering and center totals for clarity.

Discusses refining Power BI visuals with DAX for better labeling, legends, and hierarchy in bar and ring charts, and handling blanks and empty states.

Explore conditional formatting for pie chart backgrounds based on data presence, and leverage the switch function with a disconnected table to create spaced, multi-metric bar charts.

Demonstrate deneb-driven data visualizations in Power BI, using Vega-Lite to create space-saving bar charts, apply corner radii and axis tweaks, and implement field-value conditional formatting for cohesive storytelling across visuals.

Explore dynamic buttons with hover and press states, icon changes, and border tweaks. Apply drill-through navigation and conditional formatting for custom markers on charts to filter data.

Explore how to highlight specific quadrants in Power BI using conditional formatting, slicers and measures, and enhance reports with interactive headers and navigation buttons.

Explore interactive headers and dynamic narratives in Power BI visuals, using KPI cards and dual measures to display nominal and relative variances with conditional formatting.

Explore advanced features in Power BI, such as interactive tutorials and navigable report experiences using bookmarks, selection panes, and grouped elements to create guided tours.

Master element grouping and bookmarks in Power BI to enable page navigation, interactive filters, and guided tutorials within a report.

Build interactive Power BI reports by mastering button-driven navigation, bookmarks, and hover states to switch report pages, apply filters, and reveal contextual insights.

Enhance reports with advanced filters by leveraging designer kits, overlaying insights, and customizing navigation, while using embedded background designs with dynamic text and a pop-out filtering mechanism.

Design intuitive Power BI reports by using bookmarks, dynamic navigation, and pop-up filters, while grouping visuals and embedding dynamic text for clear, interactive insights.

Explore four reasons learning DAX is hard: context, filter and row contexts; bad data modeling; overusing DAX instead of upstream processing; and the quirks of time intelligence functions and offsets.

Learn how offsets standardize time analysis in Power BI, with present period zero and past and future steps, enabling flexible calendars (standard and non standard) for time intelligence.

Learn to compute the previous period and previous fiscal year in Power BI using date add and offsets, and automate these patterns with Quick Measures Pro.

Explore year to date and offset-based cumulative totals in Power BI, contrasting resetting versus overall accumulation, and learn how the extended date table controls past versus future values.

Learn to implement moving averages in Power BI using time intelligence techniques and offsets, compare a three month moving average with and without offset, and apply to net work days.

Analyze 60 business days of sales by using a weekend-aware offset that excludes saturdays and sundays, matching the standard time intelligence result and simplifying the measure.

Compare standard time intelligence and offsets performance with performance analyzer and Dax Studio; evaluate render and query milliseconds across previous period, year-to-date, moving average, and business days.

Identify the core fact table and key numeric measures—revenue, unit price, order quantity, and total cost—and choose filtering columns like dates and channels to enable high-level analytics in Power BI.

Learn to build key measures in Power BI, deriving total profits from total sales and total costs through measure branching. Extend with grouping and moving averages.

Map your report goals and plan analyses, then apply Dax formula patterns for time comparisons, trends, dynamic grouping, and ranking using moving averages, cumulative totals, and percent of total.

Integrate analysis with the analyst hub and the Dev Priorities app to plan, visualize, and tell a compelling Power BI story.

Explore how powerful visualizations in Power BI reports, including Charticulator visuals, interactive navigation, and tooltips, enable high-level analytics and compelling storytelling for enterprise dashboards.