Forum Discussion
Power Pivot - calculation using Max value
You say "the results are bizarre," which certainly would appear to be the case. What you don't say, however, is exactly which results are bizarre. Now, clearly the repeated number under the heading "Avg" needs to be questioned.
But how about the repeated number 21 under "MAX No Weekdays"? First of all, what is it (supposed to be) the maximum OF? Maximum of attendees on a Monday, Tuesday, ...etc? Maximum number of weekdays in the month? It seems equally bizarre that the same MAX number would appear in each row, as that the average would be the same in each row.
You know what your raw data contains. We don't. I realize you're the one asking for help, but it'd be easier to diagnose what's going on if we had a more complete picture of what the raw data are, what results might be reasonable in those last two columns.
Is it possible for you to post the actual spreadsheet on OneDrive or GoogleDrive (or some comparable cloud service), and then post a link and grant access to it?