Because Power Query supports a base data type for duration, we can leverage this to perform this calculation in a different manner by doing the following:
- Edit the query for R10_Table.
- Copy the Duration column and paste it into a new column, which will automatically be named Duration.1.
- Right-click the Duration.1 column and choose Change Type and then Duration.
- Click Close & Apply.
- Create a new column in the R10_Table table using the following formula:
Duration2Seconds2 =
'R10_Table'[Duration.1] * 24 * 60 * 60
In this case, when we specify a data type of Duration in Power Query, this imports Duration2Seconds2 into our model as fractions of a day. Hence, to arrive at the number of seconds, we simply need to multiply the value by 86,400 (24*60*60).