Solved: How to pull a value from a table using a list of k... - Page 2

Jordan_Davis1 · 01-11-2021 09:23 AM

I have the following tables: Opportunities, Videos, Songs, Requests. Each Opportunity has many Videos and each Video contains a Song. If someone makes a Request, it makes a new row in the Requests table which contains a Request ID, the Opportunity ID, ref values for the Videos, and ref values for the Songs.

I need to pull the Request ID into the corresponding rows of the Songs table so that I know "‘Hey Jude’ is included in Request 1 ". I tried the following expressions in a virtual column in the Songs table but nothing worked.

SELECT(Requests[Request ID],IN([Song ID], Requests[Songs])
SELECT(Requests[Request ID],IN([Song ID],SPLIT(Requests[Songs],",")
SELECT(Requests[Request ID,CONTAINS([Song ID],Requests[Songs])

Any ideas?

Steve

Ah.

FILTER(
  "Requests",
  IN([_THISROW].[Song ID], [Song IDs])
)

View solution in original post

How to pull a value from a table using a list of keys as a reference