Forum Discussion
Sequential / True Index Column
Hello All! I've been looking at a few blog posts by Greg_Deckler namely these two: https://community.powerbi.com/t5/Quick-Measures-Gallery/Sequential/m-p/380231 https://community.powerbi.com/t5/C...
Hi hnguy71 ,
You could refer to my reply of this similar thread which should be helpful.
Best Regards,
Cherry
v-piga-msft wow that's nifty! Unfortunately it gives me similar results as the RANKX measure that I'm using. I have duplicate records in my dataset and each record should increment individually. The results I have currently is this:
I'm expecting:
| PATH | GM | PL | TB | SL | Difference | SampleMeasure |
| Parent | GM1 | PL1 | 18909476 | 3724656 | -15000000 | 1 |
| Parent | GM2 | PL2 | 16689238 | 3200200 | -13000000 | 2 |
| Parent | GM1 | PL1 | 18909476 | 3724656 | -15000000 | 3 |
| Parent | GM2 | PL2 | 16689238 | 3200200 | -13000000 | 4 |
| Parent | GM3 | PL3 | 16326664 | 3160603 | -13000000 | 5 |
| Parent | GM3 | PL3 | 16326664 | 3160603 | -13000000 | 6 |