Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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! 😄
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 .
Hi Milk,
Thanks for your reply, Can you please explain how am not able to find.
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |