Average YTD Calculation in PowerPivot

[bolwahnn]

Hey Guys,

For simplicity sake lets assume I have this table of data: Name, Full Date, Month #, count (always equals 1)
Each record in the table counts as 1 error.

What I'm trying to do is get a YTD average for the number of errors in the table per Name?

In excel, I could simply do a SUMIF formula summing the number rows by name divided by a COUNTIF formula summing the number of unique Month#'s in the data set.

I have no clue on how to do this in PowerPivot. Any help would be greatly appreciated.

Thanks!