Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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? 🙂
Solved! Go to Solution.
Hi @StevieCho
My DAX formula is to create a new table, but you are creating a new column with it.
BR,
Jing
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.
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 😞
Hi @StevieCho
My DAX formula is to create a new table, but you are creating a new column with it.
BR,
Jing
Many many thanks. It works now 🙂
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
101 | |
92 | |
74 | |
60 | |
59 |