Lowest/ Highest value

[shayla]

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]

Hi, @shayla 

try below

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

[shayla]

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 · Accepted solution]

HI, @shayla 

try below

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