Forum Discussion
Newbie22
Resolver I
Resolver IDAX Help: Find Duplicate Values and Mark duplicated values as Zero and the original as One
Hi! I'm trying to find a DAX wherein I can find a duplicate values and mark the duplicate values as Zero. Here's the sample table in excel. Invoice # How many Duplicates? Desired Output ...
1) You need to create an index column.
2) write such a measure.
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26Rhl_I6iKctqi_y6pB?e=EdSNHC
Ahmedx
Super User
Super User1) You need to create an index column.
2) write such a measure.
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26Rhl_I6iKctqi_y6pB?e=EdSNHC