Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
RaviTejaLaxman
Frequent Visitor

Duration column not aggregated properly in Power BI

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.

Capture.PNG

 

2 ACCEPTED SOLUTIONS

Thanks Eric, It worked

View solution in original post

@RaviTejaLaxman

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

For any question, feel free to post. 🙂

View solution in original post

3 REPLIES 3
Eric_Zhang
Microsoft Employee
Microsoft Employee


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

Capture.PNG

 


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

Thanks Eric, It worked

@RaviTejaLaxman

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

For any question, feel free to post. 🙂

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors