DAX DUPLICATE ORDERS

[douglasgomez]

I need to create a condition so that if the value in column "A" is the same as in column "D" even if it is not in the same row, add a new column with a name that I determine.

Which DAX to do this?

[mahoneypat]

Just put "CLONE NVL" in place of the 1 inside the IF.  Also, if you don't want to see the 0, you can replace that with other text or just BLANK().

Regards,

Pat

[amitchandak]

@douglasgomez , A new column like this will give you 1 if A is found in D

if(isblank(countx(filter(Table,[A] = earlier([D])),[A])),0,1)

[douglasgomez]

And how do I get the word "CLONE NVL" instead of "1" on the line?