Forum Discussion

BIBen's avatar
BIBen
Helper I
5 years ago
Solved

LOOKUPVALUE - Basic Functionality

The Goal For each record, I want to display the name associated with each RosterKey. In the following example, the oprange table is the join table, the blue table is the roster (LookUp) table and t...
Need Help
  • ChrisMendoza's avatar
    ChrisMendoza
    5 years ago
    BIBen wrote:

    amitchandak , ...

    ...I created this Measure:...

    I believe it was intended you create 'Columns'.

  • BIBen's avatar
    BIBen
    5 years ago

    ChrisMendoza,

    I can't get mine to work like yours. One issue I uncovered is a data type mismatch. I addressed that with a FORMAT() function. Then, for some reason, I need a min(), too.

    Here is the working solution:

    Provider Name = 
LOOKUPVALUE(
    cra15_ccadroster[cra15_fullname], 
    cra15_ccadroster[cra15_rosterkey], FORMAT(min(cra15_ccadchart[cra15_providerkey]), "General Number")
)

    If you could explain the reason I need a min() I would pre greatly appreciative and would award that with another solution.

     

    Thank you for your help.

BIBen's avatar
BIBen
Helper I
5 years ago

amitchandak ,

In order to maintaina single source of truth for the roster, I'd like to create two new columns.

I tried swapping out my values for yours n your formulas, but got several errors, the first of which was "provide is not a function."

In the cra15_chart table, I created this Measure:

 

 

Provider Name = provide(Filter(cra15_roster, cra15_roster[cra15_rosterkey] = cra15_chart[cra15_providerkey]), cra15_roster[cra15_fullname])

 

 

 Would you please assist me through this next step?