Hello,
I am trying to do a select that uses the ID of reference column, but cannot get it work.
ANY(
SELECT(
Result[ID],
[Parent_ID] =
TEXT([Prev Parent Record].[ID])
)
)
[Prev Parent Record].[ID] is the key value of the table. I believe this has something to do with the issue.
Any help would be appreciated.
Dug in further. The way this is working is not making sense.
Created a virtual column to get the ID value = “f438dfb8”
Manually put the ID value into the column and the function works as expected.
ANY(
SELECT(
Result[ID],
[Parent_ID] =
“f438dfb8”
)
)
Yet, when I replace the value with a virtual column of type Text that is returning the same “f438dfb8” it returns nothing.
ANY(
SELECT(
Result[ID],
[Parent_ID] =
[Prev Parent Record ID]
)
)
Try…
ANY(
SELECT(
Result[ID],
[Parent_ID] =
[_THISROW].[Prev Parent Record ID]
)
)
Or
Lookup([_THISROW].[Prev Parent Record ID], Result, Parent_ID, ID)
User | Count |
---|---|
35 | |
31 | |
30 | |
20 | |
17 |