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!
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!
