I wonder if you can point me in the right direction. I can’t seem to find anything akin to what I am trying to do.
I have a dividends table. I know the payment frequency for each stock. The payment frequency in listed for each stock ie 1, 3 6 or every 12 months. Listed in the tickers table.
I have the date dividends has been paid but I want to create a visual that would highlight if a payment has been missed.
- How do I create the due date? Due Date would equal dividend date + month frequency for each ticker.
- If I had that, I could calculate where the latest due date showing is <=my selected date.
BUT how can I create this variable Due Date??? Can’t get my head around it. Any pointers would be greatly appreciated!
Dividends table (one of my fact tables) is linked to date and tickers tables. 1 to many