topic compare two types of data in the same column in DAX Commands and Tips

compare two types of data in the same column

LucianoS — Fri, 10 Feb 2023 21:28:56 GMT

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 ?

Re: compare two types of data in the same column

tamerj1 — Fri, 10 Feb 2023 22:06:49 GMT

Hi LucianoS

you can create a new calculated column like

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

Re: compare two types of data in the same column

LucianoS — Fri, 10 Feb 2023 23:32:54 GMT

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