Week to date Values in Line Chart

[jaimyhoff]

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

[amitchandak]

@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-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8

or 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.