Forum Discussion
Week to date Values in Line Chart
Hi all,
Im looking for a solution to present actual weektodate data into a chart.
What I have for the moment is the following:
1. A week to date forecasted value combined to a date table;
2. A dataset with actual values matches to the date table
I have in my table now the total per week.
I am looking for a measure which shows me in week 2 the sum of week 1 and 2, and in week 3 the sum of week 1 till 3 etc.
In this way i can show my Weektodate values in a Line chart.
At the moment my chart is showing the weekly individual values instead of the weektodate values
Thanks for helping out.
BR,
Jaimy
1 Reply
jaimyhoff , Are you looking for a Cumulative week total
Power BI — Week on Week and WTD , you can refer
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8or something like this
YTD= CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Year]=max('Date'[Year]) && 'Date'[Week] <= Max('Date'[Week]) ))
LYTD = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Year]=max('Date'[Year])-1 && 'Date'[Week] <= Max('Date'[Week])))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 :radacad sqlbi My Video Series Appreciate your Kudos.
