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...
Hello hnguy71,
Is adding an index column in the query editor an option for you? This would guarantee the uniqueness.
Hi jdbuchanan71 ,
my current solution uses the PQ index function but unfortunately my criteria has changed recently which requires a different approach.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
