You could use the formula bellow to deal with less dates.
Formula:
=LET(d,DATEVALUE("1-"&B$5&"-2024"),IF(COUNTIFS(Responses_Raw[Submission Date], ">="&d, Responses_Raw[Submission Date], "<="&EOMONTH(d,0), Responses_Raw[Overall Satisfaction], "<>") > 0, AVERAGEIFS(Responses_Raw[Overall Satisfaction], Responses_Raw[Submission Date], ">="&d, Responses_Raw[Submission Date], "<="&EOMONTH(d,0)), ""))
Using entire columns you may end with some interference in the calculation if you left some cell filled with numbers in 'Raw Responses' and the calculation tend to be slower.
Multiplying by * 100% is like multiplying by * 1.
Formula:
=IF(OR(ISBLANK(B6), B6=0), "", IFERROR((B6/5), ""))
Bookmarks