Forum Discussion

adityavighne's avatar
adityavighne
Continued Contributor
6 years ago

Add target column to calculated table

Hi,   I have calculated column and I want to add target for that and get difference value. How can I do this.   Name,Open,Close and total is calculated table and Target, Difeerence column I want ...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

Create a seperate 2 column Table with Names in column A and targets in column B.  Create a relationship from the Names in your existing table to the Names in the new 2 column table.  In your existing table, write these calculated column formulas:

Targets = related(table1[Target])

Difference = [targets]-[total]

Hope this helps.