I am after thoughts about creating a table which has the latest 5 quarters of data, and an additional column that shows the percentage difference between Q5 and Q1 at the end of the table (using SAMEPERIODLASTYEAR).
My page will have a quarter filter, so for the table I was thibking of having a
MAX for the max quarter, the using a date add function for each of the other 4 quarters (using - 3 months, - 6 months, -9 months etc).
This would give me the individual measures I need and then add an additional column could do a calculation using the max quarter and date add - 12 months.
BUT … is there a quicker or better way than creating so many measures.
Essentially, I want a table like
Q1 Q2 Q3 Q4 Q5 Difference
100 105 106 107 120 20%
Any comments or assistance would be appreciated.