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?