Forum Discussion

UK_User123456's avatar
UK_User123456
Resolver I
7 years ago
Solved

Average Calculation

Hi All,   I have the below data, im just simply trying to do an average calulcation for each of the ID's that I have, normally I would have just put the "Amount" into the values field and used the ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    cosminc yeah. You can use the little down arrow there to change it to any other summarization type, such as average. Or of course write an explicit measure that does the same thing. Such as...

     

    Avg Amount = AVERAGE(TableName[Amount])

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

cosminc yeah. You can use the little down arrow there to change it to any other summarization type, such as average. Or of course write an explicit measure that does the same thing. Such as...

 

Avg Amount = AVERAGE(TableName[Amount])

 

UK_User123456's avatar
UK_User123456
Resolver I
7 years ago

Hi All,

 

Thanks for the response, it just clicked to me after reading your responses that my amount for some reason when imported into power bi it changed the format to text when it should have been whole number which is the reason I couldnt summarise it.

 

Thanks