topic Re: Lowest/ Highest value in DAX Commands and Tips

Lowest/ Highest value

shayla — Mon, 04 Dec 2023 14:02:11 GMT

Hi All,

Instead having the lowest discount in the whole column, I would like to have the lowest discount % in the year as well.

how anyone help with it?

Thanks!

Dangar332 — Mon, 04 Dec 2023 14:26:42 GMT

Hi, shayla

try below

column = minx( filter( all(table), table[year]= max(table[year]) ), 'table'[discount%] )

shayla — Mon, 04 Dec 2023 14:58:48 GMT

Thanks for reply! @Dangar33

when I put the formular below, it only gives the max discount% in 2023, but I need max/min for every year..

could you please rectify my formula?

Thanks!

Dangar332 — Mon, 04 Dec 2023 15:04:03 GMT

try below

calculate( min(table[discount%]), table[year] = max(table[year]) )