Get average sales from the last 7 weeks

[Oros]

Hello,

How do you create a measure that will calculate the average sales per week in the past 7 weeks?

Thanks.

[lbendlin · Accepted solution]

You calculate the sum of sales for the last 49 days and divide it by 7.

[Anonymous · Accepted solution]

Hi @Oros ,

Below is my table:

The following DAX might work for you:

Measure = SUM('Table'[data])/7

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Oros]

Thanks @Anonymous ,

It works!

[lbendlin · Accepted solution]

You calculate the sum of sales for the last 49 days and divide it by 7.

[Oros]

Thanks @lbendlin!

[Oros]

Hi @lbendlin ,

Thanks for your reply.  How would the exact measure be?

[lbendlin]

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

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/1447...