How do I calculate the weekly amount for a time series plot?

[Anonymous]

Hi Guys,

I'm trying to plot a time series line graph with week&year and the total weekly amount. I'm not sure how to do this. 

The data looks like below but over 3 years. I would also like to use the forcast feature.

Thanks,

KC

Unique Date / Daily Amount / Weeknum

25/07/2017	51573.53	30
26/07/2017	41039.32	30
27/07/2017	29508.35	30
28/07/2017	61868.14	30
29/07/2017	34081.06	30
30/07/2017	32373.44	31
31/07/2017	74694.93	31
1/08/2017	50097.67	31
2/08/2017	39369.08	31
3/08/2017	36823.73	31
4/08/2017	34325.43	31
5/08/2017	26066.19	31
6/08/2017	19731.77	32
7/08/2017	52321.81	32
8/08/2017	46549.65	32
9/08/2017	38040.61	32
10/08/2017	63571.22	32

[amitchandak · Accepted solution]

Create a date table and try plotting on Week start date or Week end date

Week Start date = DATEADD('Date'[Date],-1*WEEKDAY('Date'[Date])+1,DAY)
Week End date = DATEADD('Date'[Date],7-1*WEEKDAY('Date'[Date]),DAY)

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s.

Refer
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi

https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/