I have a time series chart and want to mark holidays dynamically but I am having a difficult time getting it to work.
I did a calculated field just to test and requires some manipulation (creating a dual axis, syncing the axis, etc) is there a better way to do this? My goal is to load all holidays and custom dates (sale events let's say) and the holidays to automatically be marked.
Any help is appreciated.
If DATEPART('month', [Dep Date]) = 7 AND DATEPART('day', [Dep Date]) = 4 THEN