Forum Discussion
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 estou conseguindo.
3 Replies
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.
To multiply an integer column by a time column in Power Query, first ensure the time column is in the "time" data type. Then, create a custom column using the formula
= [IntegerColumn] * (Duration.From([TimeColumn]) / #duration(1, 0, 0, 0))
This converts the time column to a duration (fraction of a day) and multiplies it by the integer column. The result will be the integer value multiplied by the equivalent hours from the time column.
