MAX is not working as intended

[unitydevs]

Hi,

I'm trying to find MAX value from the PID column where the first 6 digits of the PID match with the Start Date.

MAX(
  SELECT(
    Plan[PID],
    LEFT([PID], 6) = TEXT([Start Date], "YYMMDD")
  )
)

am I missing something?

[Steve]

Is the SELECT() returning the list you expect?

[unitydevs]

I don't think so but when I tried to verify it, I couldn't figure it out how to do it. Could you please help? PID type is Number so it doesn't show the List.

[unitydevs]

Ok, I just figured out a way to verify it. The real culprit is SELECT(). what would be the correct way to use SELECT()?

[unitydevs]

Hi Steve,

I think I got this working by adding [_THISROW] in front of [Start Date]

MAX(
  SELECT(
    Plan[PID],
    LEFT([PID], 6) = TEXT([_THISROW].[Start Date], "YYMMDD")
  )
)

 but it started breaking my LINKTOFORM() function as described in Solved: LINKTOFORM() not pre-filling value if column has I... - Google Cloud Community 

can you please help?

[Steve]

---

@unitydevs wrote:

but it started breaking my LINKTOFORM() function as described in Solved: LINKTOFORM() not pre-filling value if column has I... - Google Cloud Community 

---

The other post is solved, so it isn't clear to me what the problem is now.