Since when does Int64.Type have decimals?

[Netrelemo]

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? 

[parry2k]

so if you add a next step by changing the type to whole number, does it still show decimal on change type step?

[Netrelemo]

No, it changes to a decimal then. I mean, PowerQuery is pretty bad, but not that bad (I think). 

[parry2k]

@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! ❤️

[Netrelemo]

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)