Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
45 | |
19 | |
13 | |
11 |