Lookup value without relationship

[Anonymous]

Table 1

Fullname          Frequency

Jason               3

Table 2

Fullname          Startdate          End date          Frequency

Jason               1-1-2018         1-2-2018         ? I want here the result 3

Jason               1-3-2018         1-5-2018         ? I want here the result 3

Hi,

I have 2 tables without relationship and i want the following formula:

search Table2 fullname in Table1 fullname and if there's a match give me the result of Table1 Frequency in Table2 Frequency.

the problem here is that in Table2 are multiple values of Jason and in Table1 one value.

kind regards

[Greg_Deckler]

I would think a calculated column in table 2 along the lines of:

Column = LOOKUPVALUE('Table 1'[Frequency],'Table 1'[Fullname],'Table 2'[Fullname])

[Anonymous]

i have tried calculated as new column and this the result

a table of multiple values was supplied where a single value was expected

[Greg_Deckler · Accepted solution]

It really sounds like you did that as a Measure and not a Column. I just confirmed this works. I just did a couple Enter Data queries with your data and created a Column in the 2nd table with that formula.