How To Calculate Average In Power Bi

To calculate the average in Power BI, you can use the AVERAGE function. This function calculates the arithmetic mean of a column or a set of values.

Example:

Let’s say you have a dataset with a column named “Sales” and you want to calculate the average sales amount.

    
      Sales
      100
      150
      200
      75
      
      Average Sales Amount = AVERAGE([Sales])
    
  

In this example, the average sales amount would be calculated as (100+150+200+75) / 4 = 125.

You can use the AVERAGE function in a Power BI table or matrix visualization to display the average value.