Combining MINROW() and LOOKUP()

[TedM]

So I thought I had this cracked but it's beaten me 😒

The below returns one result from 7 matching rows but I want the earliest/lowest.

LOOKUP([_THISROW].[Year/Week], "Dates", "Year/Week", "Return Date")

@Marc_Dillon  kindly pointed me to MINROW()  and I thought this would work but it gives me a "Select has invalid inputs" error.

MINROW(
"Dates", "Return Date",
LOOKUP([_THISROW].[Year/Week], "Dates", "Year/Week", "Return Date")
)

I can't find any documentation that helps stop me being hard of thinking on this one - could someone explain why it's not working or what I should be doing?

Thanks in advance 🙂

[Suvrutt_Gurjar · Accepted solution]

Could you try the below expression and see if it works for finding the row with the earliest return date?

MINROW(
"Dates", "Return Date",
[_THISROW].[Year/Week]=[Year/Week]
)

If you are looking for simply the earliest return date value and not row, the expression could be something like 

MIN(SELECT(Dates[Return Date], [_THISROW].[Year/Week]=[Year/Week]))

[TedM]

---

@Suvrutt_Gurjar wrote:

Could you try the below expression work for finding the row with the earliest return date?

MINROW(
"Dates", "Return Date",
[_THISROW].[Year/Week]=[Year/Week]
)

---

Yes it does!!

Thank you..... it looks like I was over complicating things as usual 🙄