Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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.