-
-
2. Re: YoY Growth
Sean Trout Jan 2, 2017 3:59 PM (in response to Mikhail Galichenko)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
-
Mike Galichenko - 20170102.twbx 30.8 KB
-
-
3. Re: YoY Growth
Mikhail Galichenko Jan 3, 2017 11:00 AM (in response to Sean Trout)Thank you very much, Sean. It really helped a lot
-
4. Re: YoY Growth
Sean Trout Jan 3, 2017 11:05 AM (in response to Mikhail Galichenko)Great! Glad I could help.
-
5. Re: YoY Growth
Mikhail Galichenko Jan 10, 2017 2:09 AM (in response to Sean Trout)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).