Microsoft Power BI DAX from Scratch

Create a DAX workflow using WEEKDAY to map orders by day of week, add a day number column, and define a total order qty measure for a Monday-to-Sunday view.

Use the EDATE function to compute an expiry date six months after the order date, adding a calculated column in the sales table, then format as a date without timestamp.

Learn to calculate customer age in Power BI using datediff and today, updating the age dynamically as of today; explore today, now, weekday, day, year, month, edate, and eomonth.

Extract a username from an email in Power BI DAX by using FIND to locate the @ symbol and LEFT to return the preceding characters, with optional uppercase or lowercase.

Explore the DAX if function to categorize day numbers into weekday and weekend, using the day number column to create a week status and summarize orders.

Explore how to build a nested IF in Power BI DAX to assign membership cards by income thresholds, outputting no card, silver, platinum, or gold.

Master using the and function in Power BI DAX to test multiple conditions, then pair it with if to label target customers by gender, marital status, and income.

Learn to use the DAX OR function in Power BI to test multiple conditions within an IF statement, determining eligibility for movie tickets for gold or platinum customers.

Convert day numbers to day names using the DAX switch function, mapping 1 through 7 to Monday through Sunday, with an optional else clause for handling errors.

Use the related function to fetch price per order from products and establish the relationship, then create measures for total revenue, total order quantity, total returned quantity, and return percentage.

Explore how the all function in DAX removes filters to compute the percentage of total order by category, keeping the grand total constant, and compare with all except function.

Create a calculated column to map product names to keys in the sales table using the LOOKUPVALUE function. Pulls names from product table and contrasts with related when relationships exist.

Use the distinctcount function to compute the unique customer count by the customer key in the sales table, create a measure, and display results on a card in Power BI.

Rank countries by total revenue using the RANKX function in Power BI desktop, creating a measure with ALL to ignore filters, and display star rankings via UNICHAR and REPEAT.

Explore time intelligence in Power BI DAX, including year-to-date, month-to-date, and quarter-to-date calculations, using dates YTD to build a revenue YTD measure.

Explore how to compare current month revenue to the previous month using dateadd and time intelligence functions, and evaluate against a 105% target.

Learn to compare current month revenue with the same month last year in Power BI using DAX measures such as sameperiodlastyear and dateadd, and leverage time intelligence functions.