Hi
This should be simple - it probably is, but I can’t get my head around it.
Context
I have dividend dates for each stock going back several years that are not contiguous - taken from Yahoo. Some are monthly, some quarterly, and some 6 monthly etc.
I have a table where I show if the dividend per share has increased / decreased compared to - the previous dividend date and I now want the increase/decrease compared to last dividend date less 6 months. Dateadd won’t work for that because the dates are not contiguous. Any ideas what the Dax measure is?
I’m attaching an excel export of the table.
E.g. Div 1 - last div date was 1/1/2022 (say). I want the dividend date and value 6 months prior. Previous div date was 1 month ago.
Div 2 - last div date was 12/1/2021 (s
[Dividend per share changes. I want the same data. The previous div date was 3 months ago.
etc etc
Any and all help would be great!
Dividend per share changes.xlsx (13.5 KB)
ps I can do 180 days but that’s not quite the same thing is it?!