Thanks for the simple to follow code. WIth the dataset I have I have monthly snapshots with date keys. What is the best way to deal with this?? I want to use the snapshot from the end of the month to calculate that months turnover, the next month a new snapshot is made and i use that for that month and so on and so on.
Excellent.
Thanks for the simple to follow code. WIth the dataset I have I have monthly snapshots with date keys. What is the best way to deal with this?? I want to use the snapshot from the end of the month to calculate that months turnover, the next month a new snapshot is made and i use that for that month and so on and so on.