Month on Month Trend for Sum of columns in defferent tables

[Anonymous]

So I have 4 tables,

Date,'

region,

sales and

expenses.

The sales and expenses are related to the region and Date (many to one) what I am trying to do is get the difference between sales and expense for each region on a month on month basis.

[Fowmy]

@Anonymous 

You can have the following measures on a matrix with Year-Month in Rows :

Sales Difference =  SUM( SALES[AMOUNT] ) - CALCULATE( SALES[AMOUNT] ,PREVIOUSMONTH(DATES[DATE]))


Expeses Difference =  SUM( EXPENSE[AMOUNT] ) - CALCULATE( EXPENSE[AMOUNT] ,PREVIOUSMONTH(DATES[DATE]))

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[Anonymous]

Hello, this calculates the month on month difference for sales and expenses separately which is not what i want.

i want to see the profit which is sales - expense for each month

[Fowmy · Accepted solution]

@Anonymous 

Try this measure 

Profit =  SUM( SALES[AMOUNT] ) -
SUM( Expense[AMOUNT] )

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn 

[Anonymous]

Thanks ....lol...that was easy tho....funny

[Fowmy]

@Anonymous 

When you mentioned Month on Month, it is supposed mean compare a month with another month, that was why I gave a complicated measure. 

glad it works now 

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn