topic Re: DAX DUPLICATE ORDERS in DAX Commands and Tips

DAX DUPLICATE ORDERS

douglasgomez — Tue, 22 Dec 2020 01:11:09 GMT

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?

Re: DAX DUPLICATE ORDERS

amitchandak — Tue, 22 Dec 2020 01:49:59 GMT

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)

Re: DAX DUPLICATE ORDERS

douglasgomez — Wed, 23 Dec 2020 14:08:03 GMT

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

Re: DAX DUPLICATE ORDERS

mahoneypat — Thu, 24 Dec 2020 13:30:21 GMT

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