When you use DateType field as link you lose last year sales.
So I recommend you to create datepart of month and use it as link.
And to show forecast (containing rest of current month), LOD expression will help you.
Please check attached workbook for detail.
YoY Chart_ss1_v2019.2.twbx 89.1 KB
This is great! However, is it possible to see the sales at a day level.
I.e. 15/10/19 -> 31/10/19
>>is it possible to see the sales at a day level.
Yes. To show day level chart you have to switch the order of blending table, Sales to be primary and Budget secondary, and have to create datepart of day.
But Budget table do not have daily budget (it has only monthly budget), so if you show all measures in single axis you will feel hard to see and compare details.
Thus use dual axis or remove Budget from daily view.
<sample view - using dual axis>
YoY Chart_ss2_v2019.2.twbx 122.4 KB
Thanks Shuhei - I'll review the workbook and if I have no other questions will mark as Correct.