Usually an added Index column is a Whole Number as far as my experience goes.
Why is it by default a Decimal Number in Power Query?
As a result I'm always adding a step to make it a Whole Number.
In general I'm wondering what's best practice for performance out of these options:
Because you may want to increment by .1 or .01.
Most CPUs handle floating point (decimal) numbers as efficiently as integers (whole numbers). I would not think that performance improves by changing the type to whole number.
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!