Forum Discussion
LOOKUPVALUE - Basic Functionality
BIBen wrote:
amitchandak , ...
...I created this Measure:...
I believe it was intended you create 'Columns'.
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 wrote:
amitchandak , ...
...I created this Measure:...
I believe it was intended you create 'Columns'.
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.