IF column A and B have same text then C otherwise D

[AwasthiAyush]

Hi All,

I want if its 351J in A and B then give me Work Order and if A & B is just number return Cal WO#.

How to get that?

[PijushRoy · Accepted solution]

Hi @AwasthiAyush 

Column =
IF (
    CONTAINSSTRING ( Table[ColA], "351J" ) && CONTAINSSTRING ( Table[ColB], "351J" ),
    Table[WorkOrderNumber],
    Table[Cal WO#]
)

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the Thumbs Up 👍 button if this comment helps you.

Thanks
Pijush
Linkedin

[AwasthiAyush]

Hi @PijushRoy 

Thank you for replying but I have these columns coming from different tables and we will need a measure instead of Cal Column I guess. Please see the code and how to get the desired result with this .

Final WO# =

IF (

    CONTAINSSTRING ('F4801'[Business Unit], "351J" ) && CONTAINSSTRING ( 'F4311'[Cost Center], "351J" ),

    'F4801'[WorkOrderNumber],

    'F4311'[Cal WO#]

)

[PijushRoy]

@AwasthiAyush 

Please create a pbix that contains sample data but still reflects your semantic model (tables, relationships, calculated columns, and measures). Upload the pbix to OneDrive, Google Drive, or dropbox and share the link in this thread. If you are using a spreadsheet to create/import the sample data instead of the manual import method, share the spreadsheet as well.