building a line graph with 2 different date columns

[Anonymous]

Sample File 

Hello I am trying to build a line graph with dates from 2 different columns, I have attached a sample file.

I am looking to have WeekNum on the bottom of the graph and the values would be the cumulative number of items for the week num. 

Line one would be Forecast/ Line 2 would be Actual

I can calulate the cumlative totals but I am stuck on getting a week number, that works for both cumalitve total measures

my original attempt was create an Actual weeknum column and a Forecast weeknum column, then I can create the cumulative total measures but that leaves 2 graphs / with one axis usint the actual weeknum column and the other using the forcast weeknum column  

[APavlovs]

@Anonymous 

Something like this?

[Anonymous]

not quite, it would be cumulative so each line would only go up, never down

[APavlovs]

so this? Adjusted the measure to have cumulative values - somehow missed that in the original reply 🙂

[Anonymous]

yep! how did you do that 

[APavlovs]

Reformatted your data

Used 3 measures

Did I answer your question? Mark my post as a solution 🙂