Difference between two values

[Anonymous]

Hi Team,

I have a query , In a table one column contains target and actual values, i want a column with the difference between target and actual value.

Regards,

Suresh Pantra.

[Anonymous]

Column = Table3[Actual] - Table3[Target]

[Anonymous]

Hi Milk,

Thanks for your reply, Can you please explain how am not able to find.

[Anonymous]

Ofcourse!

First select the table you want the new calculated column to be part of.

Second go to the modeling tab and click new column

At last you need to fill in the code:

and then you get this:

To further breakdown the code:

Column = Table3[Actual] - Table3[Target]

Column =  is the column name. you can change this to whatever you want. For example

Difference = Table3[Actual] - Table3[Target]

would work perfectly.

Table3[Actual] and [Target] are just the fields of your table. replace table3 with the table name of your own and Actual and Target with the correct column names.

Goodluck! 😄

[Anonymous]

Hi Milk ,

Thank you for spending time for my query. 

I have a data like this,

Account	Type	Value1	Value2	Value3
ABC	Budget	2	4	5
ABC	Target	3	6	4
DEF	Budget	3	6	8
DEF	Target	4	7	2.4
GHI	Budget	3	2.4	3.5
GHI	Target	4	5.6	3.6

In PBI Desktop if i use a slicer for account and if i select ABC i need a table like this,

Account	Type	Value1	Value	Value3
ABC	Budget	2	4	5
ABC	Target	3	6	4
ABC	Difference	1	2	-1

Can you please suggest me ASAP.

Regards,

Suresh .

[Anonymous]

Hi Milk,

Thanks for your reply, Can you please explain how am not able to find.