Appreciate any assistance on the below would be very appreciated.
Table 1:
In column PO match, I am extracting any numbers from column PO by using the EXTRACTNUMBERS() function. This gives me a list of one or more numbers. I also have a Store column.
In column Invoice, I would like to write a formula similar to the below.
ANY(SELECT(Table 2[Invoice 2], AND([_thisrow].[PO match]=[PO 2], [_thisrow].[Store]=[Store 2])))
However, [_thisrow].[PO match]=[PO 2] in my expression above is incorrect because
1. [PO match] is a list
2. I want the expression to check if one if the values in the list [PO match] is in [PO 2] (i.e. it won't be an exact match as [PO 2] data has more information than only the number that I am searching for)
I can for the love me not figure out how I should use Split(), Contains(), IN() and List() (and whatever else function) to solved this.
LinkedIn
Twitter
