Forum Discussion
IoannisT
Advocate I
Advocate ISame table TEXT lookup
Hello Fabric Community. I have searched over the forum (and other sources), but I am unable to make a same table TEXT lookup function to work. I have a raw data table with Employee name, Empo...
if you really need to use lookupvalue it should be something like this.
L2 Manager =VAR L2M = LOOKUPVALUE(PathTable[Manager-ID],PathTable[E-ID],PathTable[Manager-ID])RETURNIF(L2M=PathTable[Manager-ID],BLANK(),L2M)
-------------------------------------------------------L3 Manager =VAR L3M = LOOKUPVALUE(PathTable[L2 Manager],PathTable[E-ID],PathTable[Manager-ID])RETURNIF(L3M=PathTable[Manager-ID],BLANK(),L3M)
Bmejia
Super User
Super UserI don't know if this would work, since the value is null then you can replace the null value with the E-ID, go into transformation and add a conditional column. Then use this column instead as your manager column.
As for the other concern It think regarding data not being updated. That would be a data management issue, which you can't control would probably would still get the same wrong data in your results.
BmejiaSuper User
Super Userif you really need to use lookupvalue it should be something like this.
L2 Manager =
VAR L2M = LOOKUPVALUE(PathTable[Manager-ID],PathTable[E-ID],PathTable[Manager-ID])
RETURN
IF(L2M=PathTable[Manager-ID],BLANK(),L2M)
-------------------------------------------------------
-------------------------------------------------------
L3 Manager =
VAR L3M = LOOKUPVALUE(PathTable[L2 Manager],PathTable[E-ID],PathTable[Manager-ID])
RETURN
IF(L3M=PathTable[Manager-ID],BLANK(),L3M)
IoannisTYou are a legend!
Kudos and accepted solution.