Back to Roadmap
Level 1 — DAX Foundations+50 XP
Lesson 7
7. MIN and MAX
Extracting extreme values and dates.
The Concept
MIN and MAX return the smallest and largest values in a column, and work on numbers, text, and dates.
Example DAX:
Latest Sale Date = MAX(Sales[Date])
MAX is often used in Power BI cards to show 'Data as of' or to extract selected dates in time intelligence calculations.
Try It Yourself
Create a measure 'Max Unit Price' that finds the highest Price in the Products table.
fx
[fx]MIN and MAX=
Loading DAX Formula Studio...
Type [ for fields