Forum Discussion

TheBaz_57's avatar
TheBaz_57
Frequent Visitor
2 years ago
Solved

Find the date a min value occured.

Hi there,   I perused the forum but could find what I'm looking at.   I have this data: Name Qty Date Peter 10 01/04/2024 Tom 2 30/03/2024 Sam 5 15/03/2024 Peter 6 02/01...
Need Help
  • Arul's avatar
    Arul
    2 years ago

    TheBaz_57 ,

    try this measure,

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

     

Arul's avatar
Arul
Icon for Super User rankSuper User
2 years ago

TheBaz_57 ,

try this measure,

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