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

CalvinL's avatar
CalvinL
Helper II
6 years ago

Thanks guys, these solutions worked. Much appreciated!