Forum Discussion
Number vs Int64.type
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.
Hello Anonymous
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
2 Replies
Hello Anonymous
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
JimmyIf 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
