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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi CalvinL , you can easily do this !!!
1. select  matrix visual.
2. put columns value to Value.
3. Select average from values i.e..

Hope You will get this....
Thanks

 

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