Forum Discussion

tc97's avatar
tc97
Frequent Visitor
4 years ago
Solved

Calendar Table - Days from most recent Promo

Hi,    I'm creating an internal sales dashboard. I've created and joined a calendar table (below), and everything works fine to report on standard date periods (Date, Week, Week day, Month, Year) ...
Need Help
tc97's avatar
tc97
Frequent Visitor
4 years ago

Hi amitchandak Thanks for your quick response. 

 

Correct me if I'm wrong, but I'm not sure that approach would work for me. I think I need the two additional fields to be within the table itself.

 

The end result I'm looking for is something similar to the below, but instead of 'Month Name' in each row, I'd like "Promotion Day" (1 = Promo Start Date, 2 = Following Day, and so on)

 

This will allow us to compare each promotion against previous runs on a daily basis.

 

Hope that makes sense.