I need to create a chart (Line or Bar) to show daily sales using the available dataset. But I also keep another table to store the dates of Weekly marketing campaigns. Now I want to highlight the dai...
I recommend doing a single date dimension and implementing your business specific events in that model. You could also achieve same effect by keeping your separate event table and adding a key field in date dimension. Use bi-direction filter between date and event tables. Now you can filter on event name which would filter corresponding dates.
