Number vs Int64.type

[efroseroc]

Hi thanks for reading,

My question is, if I for example have the followig expression in power query:

Table.TransformColumnTypes(#"Filtered columns",{{"Income", Int64.Type},....

Is it better than this?

Table.TransformColumnTypes(#"Filtered columns",{{"Income", type number},....

 Or whats the difference between the two?

Because Int64 is the data type power bi automatically detected and I'm confused 

Thanks again,

Best regards,

E.

[Jimmy801 · Accepted solution]

Hello @efroseroc 

to complete @mahoneypat  answer, type number are all number (1, 1.2 etc.) whereever Int64 stands for integer meaning whole number (3,5,7)

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[mahoneypat]

If you have decimal numbers, you will need number.  I did a quick test on a column with many rows and the file size didn't change when i used the two types.

Pat