Forum Discussion

ABC11's avatar
ABC11
Icon for Resolver I rankResolver I
3 years ago
Solved

Look up laborcode in another row in same table in Dax

Hi, I have laborcode(employee no), name and laborhrs in one row And euipment, equipmenthrs , equilaborcode in different row.  Laborcode and equilaborcode is same.  I would like to identify operato...
Need Help
  • jgeddes's avatar
    jgeddes
    3 years ago

    You can change Operator Total Hrs2 to Return _calc now.

ABC11's avatar
ABC11
Icon for Resolver I rankResolver I
3 years ago

Its not pulling Operator name for employee_name.

 

jgeddes's avatar
jgeddes
Icon for Super User rankSuper User
3 years ago

I think I see it...

Replace the code as follows (in bold)...

operatorName = 
var _nameLookup =
LOOKUPVALUE(codeTable[name],codeTable[Laborcode],codeTable[Equipmentlaborcode])
Return
IF(
    OR(_nameLookup=",", _nameLookup=""),
    [name],
    _nameLookup
)