Hi
Reaching out to this forum ( looks is great on power pivot
) for help to have lookup for below scenario in data table (which is within the data table). Not sure about how to manage in DAX (PowerPivot)
my current excel formula Lookup(excel) =IFERROR(INDEX($B$3:$B$12,IF(ISNA(MATCH($C3,$D$3:$D$12,0)),MATCH("*"&$C3&"*",$D$3:$D$12,0),MATCH($C3,$D$3:$D$12,0))),"MV")
discription
IFERROR(INDEX($Cntr Desc,IF(ISNA(MATCH($ID,Previous_ID,0)),MATCH("*"&$ID&"*",Previous_ID,0),MATCH($ID,Previous_ID,0))),"MV")
Basically this help to identify ID is moving or rotating in Cntrl center.
Cntr Desc IDPREVIOUS_ID Lookup ( Excel)
RePack 134892359875 MV
Packing 748987S773119 DePacking
Packing 278457488777 DePacking
DePacking 762675999841D MV
DePacking 764309278457D-748987S-326506D MV
DePacking 748987D748987 MV
DePacking 769547543065 MV
PrePacking 769561307417 MV
PrePacking 769939769952 MV
PrePacking 773119772727 Packing
Reaching out to this forum ( looks is great on power pivot
my current excel formula Lookup(excel) =IFERROR(INDEX($B$3:$B$12,IF(ISNA(MATCH($C3,$D$3:$D$12,0)),MATCH("*"&$C3&"*",$D$3:$D$12,0),MATCH($C3,$D$3:$D$12,0))),"MV")
discription
IFERROR(INDEX($Cntr Desc,IF(ISNA(MATCH($ID,Previous_ID,0)),MATCH("*"&$ID&"*",Previous_ID,0),MATCH($ID,Previous_ID,0))),"MV")
Basically this help to identify ID is moving or rotating in Cntrl center.
Cntr Desc IDPREVIOUS_ID Lookup ( Excel)
RePack 134892359875 MV
Packing 748987S773119 DePacking
Packing 278457488777 DePacking
DePacking 762675999841D MV
DePacking 764309278457D-748987S-326506D MV
DePacking 748987D748987 MV
DePacking 769547543065 MV
PrePacking 769561307417 MV
PrePacking 769939769952 MV
PrePacking 773119772727 Packing
Last edited: