Forum Discussion
2 date fields in different table
having a calendar table makes your life much easier (because you get to use the time intelligence functions)
you can do those calculations without it but you'll have to write a bit more
look here at this link provided by Matt
http://www.powerpivotpro.com/2015/02/create-a-custom-calendar-in-power-query/
Sorry for the picture, for that metrics I am not using any measures, hope that screenshot is better
If that can help!
Well, first thing I would try would be to relate your Date from Forecasting to your Date in YTD. Then, I would see if you can drop down your Date column in your Axis and see if you can choose something like "Day". Is the format of your date something like:
1/30/2016
?
My X-axis is set to "Continuous" and "Linear" if that makes a difference.