Microsoft Power BI - Masterclass & Milestone and BEYOND

Explore the definitions of decs and tax and the logic behind them. Learn the syntax to build them in Power BI, including date conditionals, functional futures, and text in context.

Discover the logic behind dax, tax, and how to interpret and use them, with dax resembling excel for formulas. Learn to sum revenues across a table with functions and criteria.

Explore Power BI syntax by building and reading measures with calculate, filters, and nested expressions, such as selecting revenues for Europe and Italy and comparing continents and countries.

Discover DAX functions, including conditional, mathematical, statistical, and context functions, and start with the DAX function.

Explore how weekday(date) returns an integer from 1 to 7, with 1 for Sunday through 7 for Saturday, and how the default week starts on Sunday.

Learn to use the today() function to return the current date value from data fields, update values, and apply it to revenue calculations in Power BI.

Explore how LASTDATE() returns the last date in the current context, opposite of the first date, using the same syntax to obtain the final date from a date column.

Convert dates to text using the date value format with local settings, display month names correctly, and return date values by applying the datevalue syntax.

Explore how DATEDIFF calculates the interval between start and end dates in Power BI, using min and max dates to define the dataset's period.

Learn how the date() function parses year, month, and day components to produce a specific date, with examples like two thousand nine, seven, and eight, returning July eight, 2009.

Describe how the Power BI SUMMARIZE() function returns a summary table from the data, optionally groups by columns, and uses expressions to define the final values for each grouping.

Explore the removefilters() function to ignore page filters and calculate revenues across the report, even for countries like China, by erasing filter context to reveal true totals.

Master keepfilters() to adjust filter context in Power BI, using diverse expressions to produce a values table; apply Asia to calculate revenues with selective filters and name the result.

Discover how the isfiltered() function signals whether a filter is active in Power BI, returning true or false to drive conditional logic and data behavior.

Learn how to use the filter function in Power BI to filter a table by a condition and sum revenues for a specific id.

Learn how the calculate function evaluates an expression under filter conditions, using optional boolean filters and measures to compute results like revenues or current clients in Power BI.

Master calculatetable to create a calculated table from a table expression, preserving filters, using measures such as revenue, and evaluating a 2020 scenario to return the resulting table.

Explore the ALLSELECTED() function in Power BI, showing how selections preserve filters on table columns and influence the sum of revenues from orders for the current date.

Use ALLEXCEPT() to remove all filters except the current date, enabling a measure that sums revenues across tables regardless of other filters.

Explore the and() function for combining two conditional tests in Power BI, learn its syntax and how to apply it with if conditions to evaluate multiple criteria.

Learn how the OR() function evaluates multiple conditions to produce a boolean outcome, returning true when any condition is true and determining which information to display.

Explore the lookup value function, widely used in Excel, and learn how to apply it in Power BI to return a value from a table using a lookup criterion.

Explore how the iferror function handles errors in calculations, showing syntax, how to replace errors with a value, and how to manage erroneous results in Power BI reports.

Learn to use nested if functions in Power BI to classify revenues as low, medium, or high through logical tests and multiple branches.

Master how the FIRSTDATE function retrieves the earliest date from a date column in Power BI, using the syntax FIRSTDATE(column) to return a single date value.

Demonstrate how CALENDAR() and CALENDARAUTO() produce a date range between a start date and end date using date time values, with an example from 2005-01-01 to 2015-12-31.

Learn that the average function returns the mean of a set of numbers with simple syntax you can integrate. Compute the average of revenues from the orders table.

Master the averagex function in Microsoft Power BI by learning to compute the average across a table or related tables using an expression, with attention to relationships and pitfalls.

Use the divide function in Power BI to safely compute division by setting numerator and denominator, using an optional alternate result for division by zero, returning a decimal or blank.

Learn how the sum function totals revenues across orders in power bi, showing how to combine numbers to return the complete revenue sum.

Explore the SUMX function, which evaluates an expression for each row of a table, can use a filter, and may reference data from another table, presenting some complexities.

Learn how to round numbers using round(), roundup(), and rounddown() to a specified number of digits, including digits left of the decimal and negative digits, with examples showing decimal places.

Master how to use MROUND to round numbers to a specified multiple of significance in Power BI, and understand how the round function yields results based on the input.

Master min and max functions in Power BI, calculating the largest or smallest value between two expressions. Use real-world examples like revenues and discounts.

Explore how returning a 'no' value influences function outcomes, analyze the syntax, and learn when a numeric result may be required in specific cases.

Learn how the distinct() function removes duplicate values to show only unique data in Power BI, displaying unique IDs in a table column across large datasets.

Explore how COUNTX counts non-empty values across a table using a table expression and context, applying to CRM data and client names in a Power BI workflow.

Learn how countrows() counts rows in a table in Power BI to quantify the total, explore how different features affect the table, and interpret the resulting outcome.

Master the countblank function to count blank cells and apply the results to revenues from the orders table.

Master the counting function that counts non-empty values in a column, and see how it applies to an order table’s product category values for basic statistics in Power BI.

explain how to use countax to tally values across related tables, applying a category filter to compute revenues for product category 20 by evaluating an expression per row.

Explore how the right function, alongside the left function, extracts text from strings by specifying the number of characters from the right; if omitted, defaults to one character.

Explore how the left function returns characters from the start of text, defaults to one when not indicated, and includes an example using my name with three characters.

Explain how the find function locates a substring within a string, using a start position, returning its position when found and a default value when not found.

Explore how the replace function updates text by specifying the start position, number of characters to replace, and the replacement text, then see how the whole text changes.

Learn to use the related function to create a relation between tables, retrieve current values, and build a measure that sums revenues from orders across related data.

Explore the exact function for comparing two text strings in a Power BI offline database context, using exact(text1, text2) to return a boolean true or false.

Use the concatenate() function in Power BI to join text and numbers into a single string. Learn the syntax and arguments with examples of combining two text values.

Explore how CONCATENATEX joins text from tables in Power BI, using optional delimiters, and see an example combining first and last names with a space.

Explore Power BI visuals, learn how to use bookmarks and buttons, analyze performance, and integrate tips to explain what's inside for better data storytelling.

Master interactive hierarchies in Power BI visuals by expanding from year to quarter to months. Drill down to weeks and days depending on your data, viewing category level details.

Learn to group ungrouped values in Power BI by selecting items like accounting and finance, creating a new group, and naming it. Apply and manage groups within categories or projects.

Learn how to sort a visual by column in Power BI, including descending by sales, by project name, or by cost percentage, and tailor sorting to audience impact.

Power BI masterclass teaches you to toggle between a graph view and a table view, revealing deeper details like continent, employees, and totals to enhance data analysis.

Learn to use spotlight and focus mode in Power BI to center attention on a single visual by floating all other reports.

Discover how to create and configure tooltips in Power BI and how to set up a report. Explore default options you customize and reports with different types of shots.

Explore tooltips as mini visuals that appear when you hover over a visual, adding details to a Power BI report and guiding user interaction.

Create and configure a Power BI tooltip page, name it, set page size, and link it to visuals so tooltips render automatically.

Register tooltip pages by toggling the tooltip button and clicking left side icon, then tailor visual interactions—set colors, reflect values, and link data relations to display accurate cards and visuals.

Learn how to set up tooltips in a Power BI report by configuring a tooltip page and applying it to visuals for consistent, contextual insights.

Learn to revert tooltips to default, use visual format settings, and enable auto report page tooltips to improve data presentation.

Learn how to use tooltips to enhance line charts and custom reports in Power BI, including how value display behaves and how to avoid exposing unintended values.

Explore how to search, integrate a constant minimum and maximum with percent values, and use information forecasting to project outcomes for a new country.

Learn to create visuals in Power BI by adding lines that show maximum, minimum, and average, enabling audiences to compare data and highlight key details.

Speed up searching in Power BI by knowing exactly what you are looking for, integrating details into visuals, and adding constant line and minimum line.

Create and customize an average line in a Power BI visual, adjusting transparency and color, and compare maximum, average, and minimum values while layering it with other elements.

Set a constant line in Power BI graphs using defined values, such as 1,500,000 on the first graph and 750,000 on the second, to illustrate limits in wholesale data.

Learn to create a minimum line in Power BI, reflect the minimum across the payload with filtering, and style the line orange on the left and right.

Discover how to identify and display maximum values in Power BI, including selecting the maximum metric, adjusting color and transparency, and formatting the name and value on the right.

Explore creating and interpreting the median line on Power BI charts, adjusting transparency, colors, and markers to highlight key changes over the entire period.

Analyze percentile line visuals in Power BI to compare data across a range from minimum to maximum, with examples like 10 percent transparency and a group value of 776,483.

Identify how to define forecasts and trend lines in Power BI analytics, use confidence intervals to show forecast ranges, and build color-adjusted visuals to display forecasted lines.