Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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/
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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
148 | |
116 | |
104 | |
89 | |
65 |