Subtract two columns in a table

[gopi1]

Hi,

I need to subtract two columns in a table. If the user chooses any month from filter then calculated field should show me the difference. Attached picture for reference.

[v-xuding-msft · Accepted solution]

Hi @gopi1 ,

I created a sample you can have a try.

• Create a calendar table and get the month of it.  

Table 2 = CALENDARAUTO()
Month = MONTH('Table 2'[Date]) 

• Create a many-to-one relationship between two tables.

• create a measure

Measure = 
var a = SELECTEDVALUE('Table 2'[Month])
var b = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Column] = a && 'Table'[Month] = MAX('Table'[Month])))
var c = CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Column] = a && 'Table'[Month] = MAX('Table'[Month])-1))
return
IF(ISFILTERED('Table 2'[Month]), b-c, SUM('Table'[Value]))

Here is my sample that you can download.

[Anonymous]

Hi @gopi1 ,

Similar is already answerd.

You can give a try.

https://community.powerbi.com/t5/Desktop/Difference-between-two-columns-in-matrix-visualisation/td-p...

Thanks

Tejaswi

[gopi1]

In below function they are pre-defining the values but in my case the month will be in filter. User can choose any months from the filter.