Solved: Re: Find the date a min value occured.

TheBaz_57 · ‎04-09-2024

Hi there,

I perused the forum but could find what I'm looking at.

I have this data:

So I have in pbi a matrix with

Rows: Name

Values: Min of Qty

But I would like to get as well the date the Min Qty occured. And I have no idea how to gt that. Tried different solutions but without sucess.

Thanks for the help 😉

Arul · ‎04-09-2024

try this measure,

Min date = 
VAR _minQty = MIN('Table 1'[Qty])
VAR _minDate = CALCULATE(
    MIN('Table 1'[Date]),'Table 1'[Qty] = _minQty)
RETURN _minDate

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Arul · ‎04-09-2024

try this measure,

Min date = 
VAR _minQty = MIN('Table 1'[Qty])
VAR _minDate = CALCULATE(
    MIN('Table 1'[Date]),'Table 1'[Qty] = _minQty)
RETURN _minDate

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Ahmedx · ‎04-09-2024

pls try this

Find the date a min value occured.