Thank you a lot for your response! That's to close to what I am looking for. However both those measures (for example Profit) should be compared by two parameters (year and month). For example, the first measure should show data for Y2017 M7 and second for Y2016 M3.
Thank you in advance!
I guess what you really need will depend on the difference in the number of months between the 2 periods. So, in the solution I gave above, you can see that the difference is 12 months. You can create a numeric parameter with a value and make it available for the user to change as required, and use it in the above formula.
However I need to make changebale both those values on one table. Do you have any ideas how to make it?
There is the following solution:
1) Create 4 parameters: Month 1, Month 2, Year 1, Year 2
2) Create two dates as calculation fields: MAKEDATE(INT([Year 1]),INT([Month 1]),01)
3) Create dates for columns:
DATE(IF [Year Month]=[Year Month 1]
THEN [Year Month]
4) Put corresponding dates on columns and make them as dual axis.
Trust that this will help to more then just myself