LOOKUP Problem

[Anonymous]

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

[Greg_Deckler · Accepted solution]

@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.