Tag a doublicate Value in a new column

[StevieCho]

Hi People 🙂

Is it possible to display a value in a new table as a duplicate?

Here is the example:

Here I want to check whether the panel "ShiftID" is in there twice, if so: Set a "Y" in the new field, otherwise an "N".

Any Ideas? 🙂

[v-jingzhang]

Hi @StevieCho 

I see you have a filter on Type column, so I guess you have more than two different values in Type column, right? I made a simple demo table "SampleTable" like below, 

You can create a new table with below DAX: 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[StevieCho]

Hi Jing,

Thank you for your reply.

Yes, there are 3 values in the table "Type".

I have tried your solution, but i receive an error 😞

[v-jingzhang · Accepted solution]

Hi @StevieCho 

My DAX formula is to create a new table, but you are creating a new column with it. 

BR,

Jing

[StevieCho]

Many many thanks. It works now 🙂