Duration column not aggregated properly in Power BI

[RaviTejaLaxman]

I have pulled Session duration from Google analytics. When I try to do aggregations on it, it is not working properly in Power BI. Duration is getting converted into a fixed decimal number while reporting. Is there any work around for this? Also, it looks like it is performing aggregations after converting it to fixed decimal number. Does anyone know what is the logic it is applying to convert duration into fixed decimal number internally? Below is the screenshot. In query editor it was showing properly as a duration. However, In reporting model it was shown as a fixed decimal number.

[RaviTejaLaxman · Accepted solution]

Thanks Eric, It worked

[Eric_Zhang]

---

@RaviTejaLaxman wrote:

I have pulled Session duration from Google analytics. When I try to do aggregations on it, it is not working properly in Power BI. Duration is getting converted into a fixed decimal number while reporting. Is there any work around for this? Also, it looks like it is performing aggregations after converting it to fixed decimal number. Does anyone know what is the logic it is applying to convert duration into fixed decimal number internally? Below is the screenshot. In query editor it was showing properly as a duration. However, In reporting model it was shown as a fixed decimal number.

---

@RaviTejaLaxman

I'd say it is by design. There's no such "duration" type in reporting end. The logic is simple, the fraction part .1206597222*24*60*60 = 10,425 seconds, which is the same as "02:53:45". If you do care about the presentation text, check this thread Aggregating Duration/Time.

[RaviTejaLaxman · Accepted solution]

Thanks Eric, It worked

[Eric_Zhang · Accepted solution]

@RaviTejaLaxman

If no further question, could you accept that reply as solution to close this thread.

For any question, feel free to post. 🙂