Avg. Sale of a Weekday

[mlmagl14]

How do I calculate the avg sale of a weekday? For example, I have sales data from Aug1- today and I want to be able to calculate all the sales of all the Mondays and then get the avg sales of a Monday. Same for each of the other days of the week. i tried to just enter the weekday on the table and then sales number on the values field and then change it from sum to avg but it gave me a weird number. I also tried to use this DAX but it didnt work either :AVERAGEX(SUMMARIZE('Calendar','Calendar'[Date],'Calendar'[Weekday],"sum",AVERAGE('Data)'[Total Amt)])),[sum])

[v-jayw-msft · Accepted solution]

Hi @mlmagl14 ,

Add a weekday column to sales table.

Also add a weekday column to calendar table and use it as slicer.

Then create a measure like below:

measure = calculate(average(table[sales]),filter(all(table),table[weekday] = selectedvalue(slicer[weekday])))

If I misunderstood  your meaning, please share some sample data and expected result.

Best Regards,

Jay

[Ashish_Mathur]

Hi,

To your visual, drag Weekday and write this measure

Average sales = average(Data[sales[)

Hope this helps.