Weekly Count - Week by Week - Forecast Chart

[Dean1972]

Hi,

Pleaase could i ask for your help

I 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 DB

The ImportDate will be used to create the week by week count

Start date would be a Saturday

End date would be a Friday

so 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

[Greg_Deckler]

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.

[Dean1972]

Please coul i ask for some more help, i am new to BI 🙂

This is what i am trying to achive

so the column that has a monday to friday update would be the ImportDate column or what a calendar column need to be added?