Power BI Desktop: Beginner to Advanced with DAX & ETL

Enable the new on object interaction in Power BI visuals by turning on preview features and restarting Power BI to access the latest interface.

Discover the July 2023 update to Power BI on object interaction, enabling direct data and visual type changes from visuals and a customizable pane switcher via the plus symbol.

Explore the Power BI desktop interface, from data import and Power Query transformation to visuals, DAX, and publishing to the Power BI service.

Learn to build your first Power BI report by importing Excel data via the navigator, selecting visuals, and formatting charts, with best-practice tips for tables and refresh.

Finish your first Power BI report by saving, formatting visuals, adding a header, and using interactive slicers to filter regions and drive cross-visual interactivity.

Explore an advanced dataset by combining three yearly sales tables into one, establishing relationships to look up product, location, and sales details for Power BI reports.

Master advanced data preparation in Power Query Editor by importing Excel data, transforming and appending queries, renaming steps, and configuring load options for a clean Power BI model.

Create a complete dates table in Power BI using the prepared M code. Ensure time intelligence by having no missing dates for accurate measures.

Explore the Power Query Editor in Power BI, performing data transformations, including importing Excel data and splitting columns, then grouping, adding or modifying columns, and merging or duplicating queries.

Master the Power BI data model by wiring dimension and fact tables with active one-to-many relationships in model view, defining proper date connections, and using drag-and-drop relationship creation.

Create calculated columns and measures in Power BI to compute total sales by multiplying price and quantity, and compare which approach best preserves model efficiency.

Master the measures table trick in Power BI to store all measures in a dedicated measures table. Create a manual table, move measures there, and remove the dummy column.

Learn to create your first DAX measures in Power BI Desktop: build total cost with related, compute total profit and profit margin, and use divide for safe division.

Discover how DAX measures calculate on the fly, are stored nowhere, and remain flexible across any visual and dimension—from products to customers—when model relationships exist.

Learn how to use a dates table with time intelligence in Power BI, enable date hierarchy, and drill down or up across year, quarter, month, and day.

Replace auto date time with a date hierarchy in Power BI, using year and month name to enable drill up and down and boost performance on large models.

Learn time intelligence in Power BI by using Dax with the calculate function and the same period last year function to compare total sales year over year in a table.

Learn to use dateadd for flexible time intelligence in Power BI, enabling prior period comparisons beyond the same period last year by shifting dates in months or years.

Learn to create cumulative sales (running total) in Power BI using DAX, with CALCULATE, FILTER, and ALLSELECTED to accumulate up to the current date across time.

Master measure cleanup in Power BI by removing blank values with if and not blank checks, using cumulative sales and same period last year, and formatting DAX expressions.

Create a final Power BI report by configuring the canvas, applying themes and backgrounds, adding headers and KPI visuals, then build time-series and category visuals with interactive filters.

Set up a Power BI data model by importing Excel data, transforming with Power Query, and creating a date table to support a robust fact and dimension schema.

Learn to create DAX measures using sumx on the orders table, build a measures table, establish relationships with the dates table, and apply bulk currency formatting for multiple measures.

Learn how to create robust DAX measures, including profit margin using divide, and explore the parallel period time intelligence function to compare current periods with prior periods.

Learn to calculate category sales rankings in Power BI using DAX rankX, managing filter context with all and is in scope, and display dynamic rankings with a user slider.

Implement dynamic ranking in Power BI using a numeric range parameter and a slider to show the top x categories, and compare is in scope and has one value.

Master running totals and time intelligence challenges in Power BI by building a cumulative sales measure with a date table, using date add, and correcting filter context to align dates.

Explore scenario analysis in Power BI using price and demand parameters with sliders to forecast sales, visualize impact on sales over time, and compare scenarios.

Explore time intelligence in Power BI by building a rolling 30 day sales window with DAX, using calculate, filter, and all selected on the dates table.

Discover how table functions in Power BI Dax return full tables, not single values, and use them inside measures with all, filter, and values to change calculation context.

Identify and visualize the top ten clients in Power BI by building a DAX measure based on total profit, using values, filter, rank, and all, with bar and donut charts.

Explore how to compute unique customers by weekday and category in Power BI using distinct count, and visualize results with bar charts and tree maps.

Learn to replicate distinct count results using Power BI's built-in aggregations, such as count, distinct, and average, and derive insights from country and customer data without dax.

Discover quick measures in Power BI and unleash AI copilot to generate DAX expressions, creating year-to-date totals and running sums from your data.

Explore AI visuals in Power BI Desktop, including the Q&A visual, key influencers, decomposition tree, and narrative visuals, plus Quick Measures and Copilot for DAX generation.

Learn to classify customers into top, middle, and bad using a dax-based ranking on total sales, with a helper table and advanced measures for targeted visuals.

Explore how DAX variables help compare weekday and weekend sales in Power BI. Build two measures using var and return to sum weekend and weekday sales from a dates table.

Design a Power BI third report using background templates and imported images, then build visuals—timeline, bar and line charts, KPIs, and a donut chart—with white-on-dark styling.

Learn to use buttons in Power BI for navigation, back actions, information prompts, and Q&A, and configure page navigation, apply all slicers, and clear all slicers.

Explore how the calculate function changes filter context in Power BI using a two-table dataset, build a measure, and understand table relationships.

Explore how Power BI uses external and internal filter contexts, row context, and context transition, and compare calculate and calculate table to evaluate measures and tables.

Discover how to use calculate with the all and values functions to control filter context, including internal and external contexts, remove external context, and compare their behavior for conditional results.

Learn dynamic selection with calculate in Power BI masterclass by creating a unique product names table using values, then use selected value to drive total sales values with a slicer.

Apply multiple criteria filters in Power BI using CALCULATE to compute total sales between 15 and 25 with a measure, using both the ampersand and end functions.

Master using calculate with multiple criteria in Power BI, applying or logic via boolean expressions or the filter function to filter total sales between 15 and 25 or outside range.

Learn to use CALCULATE with multiple criteria across different columns in Power BI, filtering total sales by 15 and by product name monster energy, while managing external and internal context.

learn how to classify sales as low, medium, and high in the Power BI Masterclass using a classification table and a calculate with filter to count sales within defined thresholds.

Clean and set up a Power BI model using metastable trick to create a measures table, move measures, import data, fix date formats, and link a dates table for relationships.

Explore how all and allselected with calculate control filter context in Power BI to compute total sales and percent of total while preserving external region filters.

Learn how the keep filters modifier preserves external filters while applying a given expression in power bi, and compare its behavior to filter, all, and values using a category example.

Learn how calculate acts as a modifier to activate an inactive relationship using use relationship, enabling comparison of order date and ship date in the dates table for total sales.

Explore context transition in Power BI by using calculate with maxx to evaluate the maximum daily sales within a month, iterating over the dates table.

Discover the expanded table concept in Power BI, showing how employee, dates, and orders tables filter each other using calculate and ALL, and how slicers influence totals.

learn how to use calculate modifiers in Power BI to remove all filters or keep one, using all and all except to control filter context across tables and columns.

Explore time intelligence in Power BI by using CALCULATE with same period last year and moving total to compute prior-year sales and rolling 12-month totals.

Explore importing custom visuals from app source to enhance Power BI reports, using Esther plot, Sankey chart, and radar chart, and learn to pin visuals and load Excel data.

Publish your Power BI reports to the Power BI service, select a workspace, and share securely with colleagues, while managing pages and replacing the dataset as needed.

Create your own date tables in Power BI using DAX or M code, with calendar or calendar auto, dynamic end dates based on today, and optional extra columns.

Understand the difference between sum and sumx in Power BI, with sumx iterating row by row (quantity times price) and sum aggregating columns, plus how data modeling choices affect results.

Learn how to identify top and bottom customers and products in Power BI by building dynamic thresholds with measures, ranking, and slicers for flexible analytics.

Learn time intelligence, advanced visualizations, and navigation best practices in Power BI masterclass 2, including bookmarks, bookmark-triggered visuals, pop-ups, and drill-through in finance reports.

Learn cascading slicers in Power BI without bidirectional relationships. Create a measure to filter the suppliers slicer using data from the orders table and dates table.

Discover how to enable the new field parameter via preview features in Power BI Desktop to dynamically switch between measures, enabling a single-select slicer from a choose measures table.

Learn to color Power BI bars using new conditional formatting rules based on string values, such as if value equals a category or contains text, without writing measures.

Master a practical Power BI trick to conditionally color line chart dots by temporarily converting to a bar chart, applying a color measure, and then returning to a line chart.

Learn to map dates to date ranges in Power BI using the Power Query Editor, by matching episode dates to arc start and end dates through a range-based lookup.

Discover how to use ChatGPT to create DAX measures in Power BI, including a weekend-excluded total sales measure using a dates table and day-of-week logic.

Discover ibcs charts in Power BI with native visuals to compare total sales and last year using overlapping bars and error-bar delta measures.

Master dynamic formatting for measures in Power BI, an April 2023 preview feature, using switch and selected value to display country-specific currency while preserving numeric visuals.

Apply visual tooltips for images and buttons in power bi by overlaying a card visual and configuring a report page tooltip.

Learn a Power Query merge trick in Power BI to join two tables without duplicating rows by using aggregate options such as maximum, minimum, or sum.

Explore formatting options for measures in Power BI, including thousand separators, currency and unit displays, plus custom or dynamic format strings, and note format converts numbers to text in tables.

Filter Power BI tables by traffic light icons using a switch-based grouping measure and a traffic light slicer, enabling selective filtering of countries by profit margin with colored indicators.

Learn how to identify and remove unused measures in Power BI using the Measure Killer tool, with portable and admin options, and back up your report before deleting.

Use a resize measure with a placeholder of five zeros to make all Power BI table columns equal, and turn values to rows while turning off auto size width.

Master a Power Query tip to copy selected tables between reports, and learn how Mac users now access Power Query in the service via Get Data.

Learn to create your own DAX functions in Power BI by enabling user defined DAX functions, defining simple or parameterized functions, and applying them in measures.

Learn how to disable drill down in Power BI visuals and tooltips in Power BI Desktop by turning off header icons and the tooltip actions.

Learn how to control export to Excel in Power BI by enabling or restricting end-user exports, including summarized and underlying data options.