Subtracting a filter value

[lab]

Hi !

I am trying to create a measure which subtracts filtered value based on month (Current month - previous month.)

Sum of the Actual Value for June where Type = "$" - Sum of the Actual Value for Previous Month (May) where Type = "Est"

i.e.  3,300 - 1,600=700

Segment	Country	Product	Discount Band	Value	Budget/Fcst/Actual	Type	Date	Month Number	Month Name	Year
Midmarket	France	Carretera	None	2500	Actual	$	6/1/2014	6	June	2014
Midmarket	Germany	Carretera	None	800	Actual	$	6/1/2014	6	June	2014
Midmarket	Mexico	Carretera	None	1500	Actual	Est.	5/1/2014	5	May	2014
Midmarket	Germany	Montana	None	100	Actual	Est.	5/1/2014	5	May	2014

Thank you.

[dkaushik · Accepted solution]

Hi @lab 

You can try creating following measures:

CM Value= calculate(sum('TableName'[Value]), 'TableName'[Type] = "$")
PM Value = calculate(sum('TableName'[Value]), 'TableName'[Type] = "Est.", 'TableName'[Month Number] = 'TableName'[Month Number] - 1)
Diff Value = [CM Value] - PM Value]

Thanks,

Dheeraj

[lab]

Thanks !