Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

(Yet another) time query

Hello all   I've recently linked Power BI to Google Analytics, and my customer wants to focus on Average Time on the Page.     The data is brought into the model in a 'Duration' format, and look...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    7 years ago

    I think I've solved it myself!

     

    I was asking for daily data, and Power BI was trying to average, but by removing day from my query, it is retuening the expected results.

     

    Thanks for your help!

     

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi vivran

 

As the screenshot will show, I have explored the Time functions under transforming columns, and I cannot see find a seconds option:

 

 

What I did find though was the 'Duration' button lit, and that gives an option to split out seconds from the duration, and, although it doesn't deal with milliseconds, this may move me further forward.

 

Thanks for taking the time to reply

 

Daniel

 

 

vivran22's avatar
vivran22
Community Champion
7 years ago

Anonymous 

 

Hi,

 

Forgot to mention: The option I have suggested is available in Power Query and not in Power BI. You need to open the table in the Edit Query mode to access the feature.

 

Rgds,

Vivek