Forum Discussion
Help with weighted average
Hello community.
The measure Current MTD Average on the image is calculating correctly for each week, but the total of it is incorrec, beacause it should be the sum of all weeks (9,738) divided by weeks (5) = 1,957. How can I do this?
Thanks
1 Reply
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
