Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Compare the value multiple column

trying to compare the multiple columns to find  item available and item not avaialbe    Itemcode       Reference Bom           Itemcode Bom           Description   1011                    FZ      ...
"Need Help"
Help me
Help me please
Help with DAX
  • DimaMD's avatar
    DimaMD
    3 years ago

    hi Anonymous try it colum

    Status = 
 SWITCH(
     TRUE(),
     [Reference Bom] = [Itemcode Bom], "Item available",
     AND( [Itemcode Bom] = BLANK(), [Description] = "item not required - BOM"), "No issues",
     AND( [Reference Bom] <> BLANK(), [Itemcode Bom] = BLANK()), "Item Not available")

DimaMD's avatar
DimaMD
Solution Sage
3 years ago

hi Anonymous try it colum

Status = 
 SWITCH(
     TRUE(),
     [Reference Bom] = [Itemcode Bom], "Item available",
     AND( [Itemcode Bom] = BLANK(), [Description] = "item not required - BOM"), "No issues",
     AND( [Reference Bom] <> BLANK(), [Itemcode Bom] = BLANK()), "Item Not available")

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DimaMD  Thank you so much its working