Forum Discussion
YTD and Rolling average
HI, Newly learning my way around so hope someone can help! I am trying to calculate the YTD average of meetings held per week and also show thew rolling average in a bar/line chart visual. Ive use...
amitchandak
Super User
Super UserPhil_SPR , Please create week/Date dimension table and join it with your table on week/date and then try a measure like
Average DAs PW = calculate(AVERAGE(Append1[DAs]), FILTER(ALLSELECTED(Week),Week[Week Number]<=MAX(Week[Week Number])))
Thanks for the response, unfortunatly this is giving me the same result.
The issue is that there are anywhere from 2 to 6 advisers taking DAs in any given week and the formula is dividing the weekly DA total between the advisors. Not giving a weekly average of the total.