Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

LOOKUP Problem

Hello,

 

I have a problem in lookup, it gets me missing datas in local function.
I can't define if the issue is in my data model or in my function.
Function : 

old_status_name =
if(Histories[HISTORY_FIELD]="status",LOOKUPVALUE(Issues[Issue_Status_Name],Issues[ISSUE_CURRENT_STATUS_NAME],Histories[HISTORY_OLD_VALUE_NAME]))
my data model :

 


Thanks

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Anonymous Try using MAXX(FILTER(...),...) instead of LOOKUPVALUE. I have had weird results with LOOKUPVALUE due to things like DAX being case insensitive. Thus, "Category" and "category" are the same thing to DAX and this can cause LOOKUPVALUE to fail because more than one row is returned. MAXX(FILTER(...),...) has no such issue.

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    Anonymous Try using MAXX(FILTER(...),...) instead of LOOKUPVALUE. I have had weird results with LOOKUPVALUE due to things like DAX being case insensitive. Thus, "Category" and "category" are the same thing to DAX and this can cause LOOKUPVALUE to fail because more than one row is returned. MAXX(FILTER(...),...) has no such issue.