MIN and MAX in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the MIN function do in Power BI?

The MIN function returns the smallest number from a column or expression. It helps find the lowest value in your data.

beginner

What is the purpose of the MAX function in Power BI?

The MAX function returns the largest number from a column or expression. It helps find the highest value in your data.

beginner

Write a simple DAX formula to find the minimum sales amount from a Sales table.

MIN_Sales = MIN(Sales[Amount])

beginner

Write a simple DAX formula to find the maximum sales amount from a Sales table.

MAX_Sales = MAX(Sales[Amount])

intermediate

Can MIN and MAX functions be used with dates in Power BI?

Yes, MIN and MAX can find the earliest and latest dates in a date column, helping you understand time ranges in your data.

What does the MAX function return in Power BI?

A The smallest value in a column

B The largest value in a column

C The average value in a column

D The total sum of a column

MAX returns the largest value found in the specified column or expression.

Which DAX formula finds the minimum value in the 'Price' column of the 'Products' table?

A SUM(Products[Price])

B MAX(Products[Price])

C AVERAGE(Products[Price])

D MIN(Products[Price])

MIN(Products[Price]) returns the smallest price value in the Products table.

Can MIN and MAX functions be used on text columns in Power BI?

A Yes, they find the shortest and longest text

B No, they only work with numbers

C No, they only work with numbers and dates

D Yes, they find alphabetical first and last

MIN and MAX work only with numeric and date/time data types, not text.

If you want to find the earliest date in a 'Date' column, which function do you use?

A MIN(Date[Date])

B MAX(Date[Date])

C SUM(Date[Date])

D AVERAGE(Date[Date])

MIN returns the earliest (smallest) date value in the column.

What will this DAX expression return? MAX(Sales[Quantity])

A The largest quantity sold

B The smallest quantity sold

C The total quantity sold

D The average quantity sold

MAX(Sales[Quantity]) returns the highest quantity value sold.

Explain how MIN and MAX functions help analyze data in Power BI.

Think about how you find the lowest or highest number in a list.

Write a DAX formula to find the maximum date in a 'Orders' table and explain what it shows.

Use MAX on a date column to find the newest date.