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...
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)
