Forum Discussion

CalvinL's avatar
CalvinL
Helper II
6 years ago
Solved

Calculate AVG value between certain dates

Hi all,   Looking to calculate the average of a value between certain dates. Below is a sample of the data that I have.   Date   Attribute Value 01/03/2020 00:00:00   HH1 47 28/03/...
Need Help
  • Pragati11's avatar
    Pragati11
    6 years ago

    Hi CalvinL ,

     

    Looking at your sample data, you can do the following:

    • Create a table visual in Power BI
    • Move ATTRIBUTE column to it.
    • Move VALUE column to it with summarisation set to Average

     

    If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

     

    Thanks,

    Pragati

parry2k's avatar
parry2k
Super User
6 years ago

CalvinL you can easily achieve by following:

 

use matrix visual

put attribute on columns

value on values and choose aggregation to average

 

or create a measure

 

Avg = AVERAGE ( Table[Value] )

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!