Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Regards,
Mike
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.