• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculate average of TimeColumn

Simeon

New Member
Hi Friends,

i have a column with minutes in Power BI e. g. 2173, 2188, 2180 ...
I want to calculate the average of this minutes and show the average on a Card.

I tried the following but it doesn't work:

Avg = FORMAT(CALCULATE(AVERAGE('data'[Time])),"mm").


How can i calulcate the average of a time column in PowerBI?

Thanks.

Simeon
 

Chihiro

Excel Ninja
That column is in minutes? I.E. 2173 minutes, 2188 minutes etc?

When you have minutes as integer value, you must divide that by '24*60', i.e. number of minutes in a day, to convert to time value.
But it looks like you only want the minutes returned... So I assume minutes should be kept as integer/long.

=AVERAGE('data'[Time])

Will do it. CALCULATE is superfluous in this instance, as you are not using any filter expression.
 
Top