Return earliest date subject to some conditions

[o59393]

Hi all

I want to know if it's possible with Power BI to have a measure that returns me a the earliest date where the hours is different than zero .

For example I have this table:

The desired result would be:

I tried the following dax:

Most Recent Date With Hours <> 0 = 

MAXX(
    FILTER(
        'Hours by line - Official',
        'Hours by line - Official'[Upcoming New Line? (Yes/No)] = "Yes" 
&& 'Hours by line - Official'[Available Production Hours] <> 0
    ),
    'Hours by line - Official'[Date]
)

However the result with the measure above is giving me December 2024 only.

Any idea how could I get it right?

Thanks.

[Ahmedx]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Return earliest date.pbix

[o59393]

Hi @Ahmedx 

Thanks a lot. Could it be possible to have the dax measure returning the earliest date instead of a 1 or 0? 

Thanks!

[Ahmedx · Accepted solution]

MinDate = 
VAR _t = MAX( 'Hours by line - Official'[Manufacturing plant] )
VAR _tbl =
    FILTER(
        ALL( 'Hours by line - Official' ),
        'Hours by line - Official'[Manufacturing plant] = _t
            && 'Hours by line - Official'[Upcoming New Line? (Yes/No)]
            = "Yes"
            && 'Hours by line - Official'[Available Production Hours] <> 0
    )
RETURN
   
           CALCULATE( MIN( 'Hours by line - Official'[Date] ), _tbl )

[o59393]

Thank you very much @Ahmedx  🙂