Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I am wondering if someone can help,
I have a column that has duplicate values I want to create a calculated column that will count the 1st one and not the second
So first = 1
Any other = 0
I have a direct query model and as a result I’m am not able to add an index in the query editor.
If I was I would use a calculation like this
DupsID = IF('Reports'[Index]=MAXX(FILTER('Reports','Reports'[UniqueID]=EARLIER('Reports'[UniqueID])),'Leavers Reports'[Index]),"1","0")
Is there anyway first on all to add an index using DAX?
Also would I then be able to use the above DAX or somthing similar to be able to identify the duplicates?
Thanks in advance,
Boycie92
User | Count |
---|---|
124 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |