Forum Discussion

jl20's avatar
jl20
Helper IV
9 years ago
Solved

Lookup values from disconnected table

Hello,   I am struggling with an issue relating to lookups, which is best illustrated by example. Ultimately, I want to somehow pull   - Matter Data is the fact table (contains all numbers, multi...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi jl20,

     

    If I understand you correctly, you should be able to use LOOKUPVALUES function to create new calculate columns in the Timekeep table to get the names pull through based on the unique 4 digit ID number without any relationships. The formula below is for your reference. :smileyhappy:

    Orig_Prim_Name =
LOOKUPVALUE (
    Timekeep[Name],
    Timekeep[Timekeeper], 'Matter Originators'[Orig_Prim]
)

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi jl20,

 

If I understand you correctly, you should be able to use LOOKUPVALUES function to create new calculate columns in the Timekeep table to get the names pull through based on the unique 4 digit ID number without any relationships. The formula below is for your reference. :smileyhappy:

Orig_Prim_Name =
LOOKUPVALUE (
    Timekeep[Name],
    Timekeep[Timekeeper], 'Matter Originators'[Orig_Prim]
)

 

Regards