cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

Why is Index column by default Decimal Number?

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. 

  • Is it possible to add an Index column with my desired Data Type directly?

In general I'm wondering what's best practice for performance out of these options:

  • Adding extra step in Power Query for changing Data Type to Whole Number
  • Change Data Type under Data > Modeling to Whole Number
  • Leave it at Decimal Number
1 REPLY 1
mcybulski Member
Member

Re: Why is Index column by default Decimal Number?

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

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,727)