Forum Discussion

Helper I

7 years ago

Average to include blank months

Hello, is there a way that my formula can include blank months.. I am using the below formula and would like to be able to get an average of 19.06 instead of 27.24. However, Power BI will exclude...

Community Champion

7 years ago

nmckbcs

Maybe use the query editor to replace Nulls (blanks) with zero?

nmckbcs
Helper I
7 years ago
This may cause additional issues is my guess but it is an alternative I am considering if no one has a better idea. affan I added a link above in my original post.
- AlB
  Community Champion
  7 years ago
  nmckbcs
  Perhaps SUM( ) divided by COUNTROWS( Table1) if Table1 has other columns with non-blanks in the rows where the column being averaged has blanks

Forum Discussion

Average to include blank months

Related content

Calculating average 12 month average

Total per month / average per month

Dynamic Average per month Calculation

Calculating average monthly count of incidents, including months where no incidents occurred

Average for Month Excluding Current Month