topic Re: Sum Sales Average per selected period in DAX Commands and Tips

Sum Sales Average per selected period

Kopek — Thu, 12 Dec 2024 15:29:53 GMT

Hi !

I have a daily snapshot of sales data, i am trying to count the average of sum of sales for last 4 and 12 weeks.

Unfortunately i am ending up having a 4weeks daily average for some reason... can somebody help me sorting that issue.

in this case last 4 week average should be 688929. And due to daily snapshot i have 19.29...

Re: Sum Sales Average per selected period

lbendlin — Thu, 12 Dec 2024 22:26:59 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Sum Sales Average per selected period

johnt75 — Fri, 13 Dec 2024 14:13:17 GMT

Try

Last 4 weeks average = VAR Weeks = CALCULATETABLE ( VALUES ( 'Date'[Year-week] ), DATESINPERIOD ( 'Date'[Date], MAX ( 'Date'[Date] ), -28, DAY ) ) VAR Result = AVERAGEX ( Weeks, CALCULATE ( SUM ( 'Table'[Sales] ), ALLEXCEPT ( 'Date', 'Date'[Year-week] ) ) ) RETURN Result