Forum Discussion
Since when does Int64.Type have decimals?
I have a simple PowerQuery formula as follows:
= Table.TransformColumnTypes(..... ,{{"Period.1", type date}, {"Period", type date}})
= Table.AddColumn(......., "Subtraction", each (Duration.Days([Period] - [Period.1])/30), Int64.Type)
I read that and expect that the calculation will produce an Int64 datatype.
But the results are numbers like 1.03333333 and 2.033333333
Am I misunderstanding something?
4 Replies
Netrelemo what about if you change type to whole number after the calculation, do you still see it as a decimal?
👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️
No, of course it becomes an int then.
I'm able to solve the problem. My question is more educational. Is this just a bug, a feature not yet developed properly, or is that I misunderstand the meaning of Int64.Type?
Table.AddColumn(......., ......, each ...., Int64.Type)
No, it changes to a decimal then. I mean, PowerQuery is pretty bad, but not that bad (I think).
so if you add a next step by changing the type to whole number, does it still show decimal on change type step?
