Alternatively, you can insert a new column from the 'Home' tab, as shown below:
Add Reference Column
3
Enter the name of your visual column.
We want to include the order date, so we enter the name 'Order Date'. We can also change the type to 'Date'.
Type and Column Name
4
Enter the column and table details that you want to refer to.
Enter the connection details, schema name, reference table name, column to be referenced, and the column that corresponds to both current and reference tables. Click Save.
In the example below, we have referred to the 'Orderdate' column from the 'Sales' table, whose connection details we have entered.
Table details
The visual column is added to the table, and it looks as shown below:
Reference column added
Reference columns are non-editable, and their values only change when the underlying column values change.