Forum Discussion
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...
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.
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
Memorable Member
Memorable MemberWelcome, kudos (thumps up are always welcome)