-
-
2. Re: YoY Growth
Mike,
1) To find the growth for a particular month from on year to the next, you can use LOOKUP function to create a calculated field. The calculation looks something like this:
2) In the attached workbook, I created a parameter that allows you to select the month that you want to compare. Then I created a dimension for the month name, using a DATEPART function to get the month number. I called this dimension "Month Name". That can now be used to create a boolean filter, where that month name must equal the month selected in the parameter. The final step is to duplicate the calculation shown above and change the -13/-12 to -1 and you should be good to go.
Hope this helps.
Sean
-
-
-
5. Re: YoY Growth
Sean, I have one more question.
is it possible to do the same, but add one more filter - year. So I can choose year and month. Just to be clear, I want to be able to choose month and year (for example, August 2016) and to see difference compared with previous year the same month (August 2015 in this case).
I tried to implement the same logic as with month in your example, but when I choose one month and one year the calculation shows nothing (null).
Dec 30, 2016 5:25 AM
