Weekly Count - Week by Week - Forecast Chart

Question

Hi,&nbsp;Pleaase could i ask for your helpI am new to BI and need to create a report that shows a week by week count.So the infomation is pulled in via an Access DBThe ImportDate will be used to create the week by week countStart date would be a SaturdayEnd date would be a Fridayso the line chart should show - 29 -09 - 2017 / 06 - 10 - 2017 / 13 - 10 - 2017 (for the whole duration 2016/2017/2018)then i would add the milestone stages, aligned end date, target qty&nbsp;&nbsp;

greg_deckler · Answer

Seems like there is some information missing but I think I get the gist of it. What I would do would be to create a calculated column using the WEEKNUM function.

https://msdn.microsoft.com/en-us/library/ee634572.aspx

Then you could aggregate based upon the week number.