June 24, 2020
Hello friends, Hope all is well & Safe!
Please help me, with a DAX formula in a new created column. Please look at the photo.
* You can see that the 1st & 2nd rows match the year, month, day, branch, and ID, I want the 1st row to be 1, 2nd row to be zero and so on.
* 3rd & 4th rows match the year, month, day, branch, and ID, I want the 3rd row to be 1, 4th row to be zero and so on.
* Some rows can have more than 2 duplications, so show the 1st common fields show 1, and the rest of the matches 0.
Thank you so much in advance!
July 16, 2010
You can't do this in Power Pivot, but you can with Power Query. This tutorial on numbering grouped data in Power Query should point you in the right direction. You'll have to modify it slightly by adding another column that numbers rows =1 with 1 and anything >1 with 0.
If you get stuck, come back and share your sample Excel file with your data and query attempt.