Forum Discussion
Difference between two values
Column = Table3[Actual] - Table3[Target]
Hi Milk,
Thanks for your reply, Can you please explain how am not able to find.
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! :D
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 .