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

v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi  CalvinL ,

 

You can create 2 calculated columns as below:

 

Month = FORMAT('Table'[Date.1],"MMMM")
Column = "Average of" &" "&'Table'[Attribute]&" "&'Table'[Month]

 

Then create a matrix visual,put column in the field of "column" ,value in the field of "value",right click on value,select "average":

And you will see:

For the related .pbix file,pls click here.

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!