Return the year where with the MIN value in unemployment rate 12

[FJME]

Dear friends,

i have a column with the unemployment rate through 3 years ans i want to return  the year (other column in same table) where the unemployment rate is the MIN.

Can you help in simplest DAX formula to achieve it?

[Mikelytics]

Aweseome! Thank you for your feedback!

[Mikelytics · Accepted solution]

Hi @FJME 

Please try the following measure:

Year with Min Value=

CALCULATE(
   MIN(Table[Anos]),
   Table[%Desemprego] = MIN(Table[%Desemprego])
)

Or the following to cover situations when multiple years have the min value

Year with Min Value=

CALCULATE(
   SELECTEDVALUE(Table[Anos],"multiple years"),
   Table[%Desemprego] = MIN(Table[%Desemprego])
)

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

[FJME]

Thanks a lot!

Both performs as intended.

Regards