Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
I have a set of data like this. For the ID, they have duplication under different "Record Date". What I want to do is to create a new column to check if the "ID" have duplication, it will show "Y" for the oldest record and "N" for the remaining. For the "ID" without duplication, it will always show "Y". Thank you.
ID | Record Date | Expected Result |
A | 2022-06 | Y |
A | 2022-07 | N |
A | 2022-08 | N |
B | 2022-07 | Y |
C | 2022-06 | Y |
D | 2022-06 | Y |
B | 2022-08 | N |
Solved! Go to Solution.
Hello,
Try this
Hello,
Try this
User | Count |
---|---|
86 | |
82 | |
68 | |
65 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |