Forum Discussion

jl20's avatar
jl20
Icon for Helper IV rankHelper 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

Aron_Moore's avatar
Aron_Moore
Icon for Solution Specialist rankSolution Specialist
9 years ago

I use lookupvalue in this model which doesn't use related to get text for the account number. You may need to create another key column by concatenating a couple of columns.