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 |
---|---|
42 | |
28 | |
25 | |
22 | |
13 |