Forum Discussion

lab's avatar
lab
Frequent Visitor
5 years ago
Solved

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 ...
Need Help
  • dkaushik's avatar
    dkaushik
    5 years ago

    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

dkaushik's avatar
dkaushik
Resolver II
5 years ago

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's avatar
lab
Frequent Visitor
5 years ago

Thanks !