How to subtract previous month with category from two tables

[Anonymous]

Hi, 

I would like to ask this.

So, Currently I have these two tables

Brand	Month	Revenue
A	1	1000
B	1	200
C	1	500
D	1	700
A	2	2000
B	2	400
C	2	550
D	2	600

and 

Brand	Brand Category
A	Milk
B	Milk
C	Chocolate
D	Chocolate

So the result that I want should look like this

So what I want to ask is how to get the difference revenue from current month and previous month from the two tables that I have.
Example for Milk the difference is 2400 (revenue in 2nd month) - 1200 (revenue previous month) = 1200

Thank you

[Anonymous]

@Jihwan_Kim Thank you so much it helps!

[Jihwan_Kim · Accepted solution]

Hi,

please check the below picture and the sample pbix file's link down below.

All measures are in the sample pbix file.

sample pbix file LINK