Forum Discussion
Solved
Coluna personalizada no Power Query
Como incluir uma coluna personalizada que multiplique uma coluna com valor inteiro por uma coluna de hora? O Excel converte a hora em número serial e multiplica normalmente, mas no power query não es...
It works in Excel because Excel stores times as numbers.
But what is your point of this multiplication in Power Query?
I ask because Power Query does has both a Time data type as well as a Duration data type. In Excel, both are stored as numbers and can be displayed in a variety of methods.
In Power Query, a "time" data type cannot be equal to or greater than 24 hours.
A "duration" data type can be, and can be multiplied by an integer with the result being a duration.
If you are really multiplying a Duration by an integer, then ensure your "time" is a Duration type, and merely multiply it.