Previous Day compared to YTD Avg of Same day of week (DAX Help Please)

[cwnoll]

I am trying to compare a total from Monday (4/6), with the YearToDate Average of the same day of week. For example, I want to compare the total from Monday (yesterday) to the YTD average for all Monday's this year. FYI on example data below, I removed all other dates besides Monday in effort to save space. The original data source has all days.

Date	WeekDay	Answers
4/6/2020	Monday	914		Monday	914
3/30/2020	Monday	830		Monday YTD Avg	1046
3/23/2020	Monday	915		Monday Diff	-132
3/16/2020	Monday	1009
3/9/2020	Monday	1069
3/2/2020	Monday	1143
2/24/2020	Monday	1099
2/17/2020	Monday	1044
2/10/2020	Monday	1082
2/3/2020	Monday	1093
1/27/2020	Monday	1154
1/20/2020	Monday	942
1/13/2020	Monday	1143
1/6/2020	Monday	1073
3/23/2020	Monday	915

[Greg_Deckler]

All Mondays = AVERAGEX(FILTER('Table',YEAR([Date]) = YEAR(EARLIER([Date])) && [WeekDay] = "Monday"),[Answers])

[cwnoll]

will give it a shot, thank you for quick response. the goal is for this to be a moving target for each day. So tomorrow obviously i would be doing this for Tuesday. Would you just create a var for current day of week -1 so that it would auto change each day, or different measures for the days?

man i hope that made sense.

[amitchandak]

@cwnoll , Same weekday is 364 days behind, use with date calendar

Week Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-364,DAY))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/