Forum Discussion
Weekly Count - Week by Week - Forecast Chart
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...
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.
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?
