Measure for sum of a column based on values in two other columns

[JuanBolas]

Hello,

I'm trying to get the variation of the sum of two individual columns (ThisMonth and LastMonth) by client name.  This is to be included in a table which has the top 10 ordered by trips this month (ThisMonth) in descending order.  The table fields are Client Name, ThisMonth (as bar chart), LastMonth, and a Sparkline showing the last 12 Months.  This is all working OK, but I can't get the variation/change to work ([ThisMonth]-[LastMonth])/[LastMonth]).  Both ThisMonth and LastMonth are calculated columns. 

My data is something like this:

ClientName                     ThisMonth                LastMonth

Joe                                   1                               1

John                                 1                               0

Susan                                                                1

Joe                                    1                              0

Joe                                    1                              0

John                                  0                              1

Sue                                    1

Thanks in advance for your help.

[v-easonf-msft]

Hi, @JuanBolas 

What is your expected result?

Can you display the result in a table?

Best Regards,
Community Support Team _ Eason

[JuanBolas]

Thanks for your message.

What I'm looking for is a third column with the variation/change calculated as ([ThisMonth]-[LastMonth])/[LastMonth].

Thanks.