Hi Experts, I would like to look for a single cell of data in column "locator", in the whole column "order" - not just vertically. I then need it to result in "Yes", if there's a match and "No" if there is not.
I have tried many different Dax functions (Contains, Search, Valuelookup) etc but can't get the correct result.
The problem I have is the matching data sits in a different row - example below. Please note: they are set as text fields, not numbers. And they need to remain as text.
Would you mind to explain what | | part of the syntax does / means?
I have a different problem with the same data, which I thought I knew how to solve..
First I look at the Inventory Month column and only want to see a 'TRUE' if the result is "CURRENT" & the CONTAINS formula is 'TRUE' this works perfect as it is. Next I look at the Subinventory Code, and only want a 'TRUE' if = B2B and as above. If Subinventory Code is not "B2B", I want the result to be an empty cell/blank.. and not 'FALSE'..