Forecast v Planned Date

[kellis]

Hi everyone, 

Please could you help me with the following. 

I have planned start date and actual start date columns - how do I use this data to create a line chart showing the difference?

Thank you, 

K

[v-stephen-msft]

Hi @kellis ,

Sorry to disturb you...

But did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Stephen Tao

[v-stephen-msft · Accepted solution]

Hi @kellis ,

Assuming your planned date column and forecast date column are from different tables, then you need to create a calendar table to connect these two tables, as follows.

Then put the date column in the calendar table into the axis, create the following visual

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy]

@kellis 
Can you share some sample data with the desired output to have a clear understanding of your question? Mention whether you want a calculated column or measure
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.