Multika

The Problem

I have column with multiple distinct values which I want to rank dynamically by some measure. I understand that this is computationally expensive. But I expect to have filters such that I am not ranking all values but only a few thousands.
I get correct results but it takes far longer than expected (multiple seconds vs. tenths of seconds). I hope to get a way to optimize my code.

The setup

I tried the following with the 10M Contoso PBIX which you can download from here: https://github.com/sql-bi/Contoso-Data-Generator-V2-Data/releases/tag/ready-to-use-data
It's not exactly my real example but similar enough. You can try yourself and check my results.

The file has

In finance, this is known as rule of 70, but it is applicable for everything growing exponentially.

Examples:

• If you invest 1000 $ at 7 %, you will have 2000 $ after about 10 years.

• 2 % inflation means that prices double about every 35 years.

• With 1.2 % population growth, the world population will double about every 58 years.

• 100 % growth means doubling every 0.7 years. This formula is most accurate for small percentages (over 96 % accuracy for growth rates less than 10 %, over 92 % accuracy for growth rates less than 20 %).

Hey, r/NVC, I'm grateful to have this community. It's nice to have a safe place to express oneself in NVC terms and learn more about it. It's probably (and sadly) not that uncommom that people on the NVC path experience some kind of internal (or even external) pressure to use it "right". I'd rather recommend you to remind yourself that you have choice about how you communicate and perhaps use that to decide to use NVC - if you want to - out of the perceived effectiveness in meeting your needs with it. Maybe you are then like me who finds it liberating to being able to express himself in sometimes formal giraffe without much worrying about possibly confusing people with that unusual language.