cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Subtracting a filter value

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.

1 ACCEPTED SOLUTION
Resolver II

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

2 REPLIES 2
Resolver II

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

Frequent Visitor

Thanks !