Forum Discussion
Lookup value without relationship
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
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.
3 Replies
I would think a calculated column in table 2 along the lines of:
Column = LOOKUPVALUE('Table 1'[Frequency],'Table 1'[Fullname],'Table 2'[Fullname])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.