compare two types of data in the same column

[LucianoS]

Hello, I am looking for a way to perform a comparison between two types of data, that is:

I have the document types "FCC" and "GRC", both can be from the same document number in the "nudo" column, so what I want to know is which dax function can deliver the data that is in FCC but not in GRC ?

[tamerj1]

Hi @LucianoS 

you can create a new calculated column like 

IF ( CONTAINSSTRING ( 'Table'[nudo], "FCC" ), "Yes", "No" )

[LucianoS]

Sorry, I'm using the translator. nudo is one column, "fcc" and "GRC" is in another column called "TIDO"