Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Help calculating daily average

Daily Average Sales= AVERAGEX(KEEPFILTERS(VALUES('LNApps_AppDateDim'[ActualDate])),CALCULATE(SUM('LNApps_Facts'[Total_Sales]))) I am trying to get the daily average sales, but the numbers the formu...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi Anonymous,

 

You can create a calculated column to return weekday, then create a measure use AVERAGEX() function: 

 

WeekDay = WEEKDAY('Table1'[Date],1)

 

DailyAverageExceptWeekends = AVERAGEX(FILTER(ALL('Table1'),'Table1'[WeekDay] <> 7 && 'Table1'[WeekDay]<>1 && MONTH('Table1'[Date])=MONTH(MAX('Table1'[Date]))),'Table1'[Sales])

 

 

For more information, you can download attached pbix file for a look. 

 

Best Regards,
Qiuyun Yu