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.

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.

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.

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.

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.