6 Replies Latest reply on Jan 12, 2018 2:45 AM by David Maning

# Selected measure comparison for two period in one table

Hi guys!

Would you be so kind to help me with the following issue. I need to compare the same measure for two different periods. Those periods consider of two different parts each: year and month.

So finally there should be a bar graph, each bar related to corresponding period (chosen month and year).

Kind regards,

David

• ###### 1. Re: Selected measure comparison for two period in one table

Hi David Maning, so you want a bar chart view with one bar showing the measure value for one order date and the other bar for another order date ?

• ###### 2. Re: Selected measure comparison for two period in one table

Would something like this help?

• ###### 3. Re: Selected measure comparison for two period in one table

Hi Hari!

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.

Kind regards,

David

• ###### 4. Re: Selected measure comparison for two period in one table

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.

• ###### 5. Re: Selected measure comparison for two period in one table

However I need to make changebale both those values on one table. Do you have any ideas how to make it?

Kind regards,

DImitriy

• ###### 6. Re: Selected measure comparison for two period in one table

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]

END)

4) Put corresponding dates on columns and make them as dual axis.

Trust that this will help to more then just myself

Kind regards,
Dimitriy