Average per weekday

[Anonymous]

Hi,

i need a column of measure what shows the average per weekday. Example there are as in the picture three tuesday with totals 176,7 and 12 and the result must be 65.

[v-frfei-msft]

Hi @Anonymous,

To create two calcualted columns as below.

TOTALS = CALCULATE(SUM(Table1[Number per day]),ALLEXCEPT(Table1,Table1[Submit Date]))

Result = SUMX(VALUES(Table1[Submit Date]),CALCULATE(MAX(Table1[TOTALS]),ALLEXCEPT(Table1,Table1[Submit Date])))/DISTINCTCOUNT(Table1[Submit Date])

For more details, please check the pbix as attached.

Regards,

Frank

[Anonymous]

thank your for the answer, but i need an average per weekday and not per submit date. if i put more data in my datasets with different weekdays i don't get the right result.

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Could you please share your sample data and excepted result to me, if you don't have confidential data? Please upload your file to One Drive and share the link here.

Regards,

Frank