Goal: Find the cheapest (MIN) or most expensive (MAX) product.
Watch the "Current Record" update only when a better value is found.
Select a formula...
💻 DAX Formula
-- Scenario 1: Find Lowest Price
MEASURE Lowest Price = MIN( Products[Price] )
-- Returns the smallest number in the column
-- Scenario 2: Find Highest Price
MEASURE Highest Price = MAX( Products[Price] )
-- Returns the largest number in the column