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 wa...
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.
I would think a calculated column in table 2 along the lines of:
Column = LOOKUPVALUE('Table 1'[Frequency],'Table 1'[Fullname],'Table 2'[Fullname])i have tried calculated as new column and this the result
a table of multiple values was supplied where a single value was expected
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.