For an historical set, I'd like to show the last value of a measure, and the date associated. The problem is that my measures don't have the same last date.
Then I want to show the values at: - [last date]-one week
- [last date]-one month
- [last date]-three months
- [last date]-six months
- [last date]-one year.
Here attached are the goal file (target), the try file (my code), and a sample of my set of data.
Any advice would be greatly appreciated.