Forum Discussion
Dynamic Previous Period Comparison
Hello friends, I would like to build a measure that would compare Sales in a Current Period vs. Previous Period. The catch here is I would like it to be dynamic, so when my user chooses a certain m...
I think it is doable, first create three measures for Previous month, quarter and year and then create one more measure which will look at what is selected (month, quarter or year), and based on that dynamically change the value of this measure.
Just to clarify, you have slicer on your report to select month, quarter or year, correct?