Forum Discussion

wcameron14's avatar
wcameron14
Frequent Visitor
6 years ago
Solved

Duration Displayed on Card

Hello,   I am working with Google Analytics data and attempting to display a card with the Average Session Duration. I have created a custom column to display this data on my table in Power Query w...
card
duration
Google Analytics
Power Query
  • stevedep's avatar
    stevedep
    6 years ago

    What you could do is create a calculated column:

     

    averagepersessioncol = 'Table'[Total Session Duration]/'Table'[Sessions]

     

    And a measure:

     

    durationpersession = Format(AVERAGE('Table'[averagepersessioncol]); "HH:MM:SS")

     

    For the 3rd and 4rth row this yields:

    Which is the average of averages.. like here in excel:

     

    Link to Power BI file here. 

     

    please mark as solution if this works for you.

     

    Kind regards, Steve. 

wcameron14's avatar
wcameron14
Frequent Visitor
6 years ago

This still displays a decimal on the card. Maybe there's something I'm doing wrong with the formatting of my visual?

stevedep's avatar
stevedep
Icon for Memorable Member rankMemorable Member
6 years ago

What you could do is create a calculated column:

 

averagepersessioncol = 'Table'[Total Session Duration]/'Table'[Sessions]

 

And a measure:

 

durationpersession = Format(AVERAGE('Table'[averagepersessioncol]); "HH:MM:SS")

 

For the 3rd and 4rth row this yields:

Which is the average of averages.. like here in excel:

 

Link to Power BI file here. 

 

please mark as solution if this works for you.

 

Kind regards, Steve. 

  • wcameron14's avatar
    wcameron14
    Frequent Visitor
    6 years ago

    This helped with the formatting. My formula isn't quite right but I think I can figure it out from there. Thanks for the help!

    • stevedep's avatar
      stevedep
      Icon for Memorable Member rankMemorable Member
      6 years ago

      Welcome, kudos (thumps up are always welcome)