Hi ,
I have caculated YOY , MOM , and QOQ but in different sheets. Is there a possibility to get the metrics in Single sheet. I have aattached the workbook .
Thanks
3 answers
My first piece of advice would be to read some more about Table Calculations. You've gone to a lot of effort that you don't need to get a subset of the data, and then do the calculations. I'm attaching a workbook with one example worksheet containing the 3 measures for [Num Users]. The key difference with my approach is that I just do the calculation on all of the data, then filter the results down to the month I want to look at. It took 3 calculated fields, two for the values, one for the filter.
