Forum Discussion
Serial Number for union table duplicates
Hello Folks, How are you guys ? Im able to generate the column "Stop" for the table as shown below Uniqueid BLM Stop Store Date of plan AA1s1 AA1 1 s1 09/21/2020 10:00 AA1s2 AA1 ...
Anonymous
You need to add a helper column to your table like:RankSupport = [Date of plan] + RAND()Then add the STOP column with this code:
Stop = RANKX( FILTER(Table5,Table5[BLM] = EARLIER(Table5[BLM])), Table5[RankSupport],,ASC,Dense )________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
Anonymous
You need to add a helper column to your table like:
RankSupport = [Date of plan] + RAND()
Then add the STOP column with this code:
Stop =
RANKX(
FILTER(Table5,Table5[BLM] = EARLIER(Table5[BLM])),
Table5[RankSupport],,ASC,Dense
)________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
Thanks a lot it worked 🙂