Forum Discussion
How do I RANKX over text duplicates?
Hi, I've tried some of the examples of text rankings in this forums, with little to no success. Here's what I'd like to achieve: My goal - filtering out all values that are different t...
Anonymous , As suggested by mahoneypat , Add an index column and try a formula like
https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
countx(filter(Table, [Index] <=earlier([index]) && [ID] = earlier([ID])),[ID])
Hi, thanks for the help but I can't use "Edit Queries", because I'm using live connection, which disables that feature.
I also tried the COUNTX example but PBI throws an error, saying the syntax is wrong.