I have a calculated measure (OpenRate%) in QS and in my result set I also have MonthName being returned.
I am trying to calculate the difference in the measure vs previous month.
Are there any inbuilt functions that I can use to achieve this or is this more complex than it sounds?
Maybe [OpenRate%] - above([OpenRate%])
Wow! That was easy... works a treat (I think, just sanity checking the values)
Retrieving data ...