Forum Discussion
average calculation problem
Hi! I´m having a problem but i cannot find the cause. I make a survey to my customers for them to rate my service from 1 to 5 and some of them may not respond, as you can see in the capture. ...
Yes! Excel calculates an average of 4.39 while power bi an average of 4.42
the data in the capture of the post was an example, i would attach the xlsx file but i doesn´t let me.
This screenshot does not align with your example table. I only see two rows in your sample data for that quarter (one for each Client), so it's unclear to me why neither of the averages is a simple 3.5.