Forum Discussion
AVERAGE measure produce error
Posted this earlier but a moderator thought it was spam... It isn't.
I have only just begun using Power BI and I'm following along with some YouTube videos. I thought I had a good grip, so would create a visual off of my own data, but I am stuck!
I have a spreadsheet with a number of columns in. The most interesting ones are labelled "Item ID" (a unique reference) and "Time to Accept" which is hh:mm:ss. I want a card to show me the average time to accept value across each of my rows. I've selected the "Item ID" field and the "Time to Accept" fields which has produced this table:
I've then clicked Home -> New measure and entered "Average Time to Accept = AVERAGE(Sheet[Time to Accept])" but now the visual displays an error "Can't display the visual":
When I click "See details", here's what I see:
You can't use the Time datatype. You have to use DURATION.
14 Replies
Hi Anonymous ,
Could you please tell me have you solve your issue now? If so ,please kindly provide the solution and mark your reply. If not, please provide your pbix file without privacy information and desired output with more details.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous that means the data type of the column is text.
Change the data type to time in Power Query and close and apply.Anonymous can you start from scratch and update me you still get the error?
