Forum Discussion
Average for week
Hello, I am trying to create a column that will find the average weekly sum, from Monday thru Sunday. For example, for every [Date] record that contains Feb 1, it would show the average of all [...
patri0t82 , create a week from Monday to Sunday. refer my blog
and have a measure like
averagex(Values(Date[Date]), calculate(sum(Table[Value])))
Any Weekday Week - Start From Any day of Week
https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8