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")

ValtteriN's avatar
ValtteriN
Community Champion
3 years ago

Hi,

Here is one way to do this:

Measure 25 =

           
SWITCH(TRUE(),
        IF(IFERROR(
            SEARCH("item not required - BOM",MAX('Table (15)'[Description])),FALSE())=1,TRUE()),"No Issues",
MAX('Table (15)'[Itemcode Bom])=MAX('Table (15)'[Reference Bom]),"Item Available",
MAX('Table (15)'[Itemcode Bom])<>MAX('Table (15)'[Reference Bom]),"Item not Available")


End result:

Edit:

If you want to check for blank in the first case you can modify the dax like this:

Measure 25 =
SWITCH(TRUE(),
        AND(IF(IFERROR(
            SEARCH("item not required - BOM",MAX('Table (15)'[Description])),FALSE())=1,TRUE()),
            ISBLANK(MAX('Table (15)'[Itemcode Bom]))),
            "No Issues",
MAX('Table (15)'[Itemcode Bom])=MAX('Table (15)'[Reference Bom]),"Item Available",
MAX('Table (15)'[Itemcode Bom])<>MAX('Table (15)'[Reference Bom]),"Item not Available")


I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/


Anonymous's avatar
Anonymous
Not applicable
3 years ago

ValtteriN  Thank you so much for reply