How to calculate month-on-month comparison?

[#1]

As we can see from the picture above,there are two columns and two lines in the chart.

I have already add two columns and the expressions are used as follows:

ADamount: sum({$<cal_month={"2014*"}>}[AD_amount])/1000

Receiveamount: sum({$<cal_month={"2014*"}>}[receiveamount])/1000

But how to add two lines as month-on-month comparison?

[tresesco]

Use combo chart. Four expressions. In the expression tab, you can select an expression and choose bar/line from display options.

[#3]

I know it need combo chart. But how to write the expressions?

[#4]

Can anyone solve the problem?

[#5 · Accepted solution]

Can't you try using above.

Sum(AD_amount)- Sum(above(AD_amount)) as the MOM Expression?

[#6]

Thank you for your reply.

But when I use your expression,it doesn't show any number,why?

[#7]

Oh, I've modified the expression to:

sum({$<cal_month={"2014*"}>}[AD_amount])/1000/Above(sum({$<cal_month={"2014*"}>}[AD_amount])/1000)-1

And it works.

Thank you very much.

[#8]

can you mark the thread as 'Answered' please?

[#9]

Done. Thank you very much.

[#10]

hi Joy, would you mind share this chart.