Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 ...
average
error
Formula
  • daXtreme's avatar
    daXtreme
    4 years ago

    You can't use the Time datatype. You have to use DURATION.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi, thanks for the quick response. I changed the data type to "Time" but forgot to save/apply it. I've gone to redo it but now it's complaining that it cannot automatically convert the column:

 

 

SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous can you start from scratch and update me you still get the error?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I deleted the measure and restarted Power BI Desktop but am still getting the error.

    • SpartaBI's avatar
      SpartaBI
      Icon for Community Champion rankCommunity Champion
      4 years ago

      You do that in power query?

      Can you share your model?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Sorry, I was doing this in the "Data" panel:

         

         

         

        When I open "Transform data", I went into the Transform tab and changed the Data Type to "Time" there:

         

         

        This seems to have worked, but now I have another problem as the values say "Error":

         

         

         

        Is there some sort of maximum figure? It should show 29:41:41 as per the yellow bar.