Forum Discussion
Use calculate to work out previous years instance
Hi, I am wanting to use a variance against the previous year but I am unable to do same period last year as I am going of a custom column called instance rather an a date. The instance is the...
Abduvali
Skilled Sharer
Skilled SharerAnonymous
I think if you just create a new measure with following calculation (2016 Total - 2017 Total) to what you already have and you will get your variance column, and you can filter by anything you want it will do the calculation for you.