Updating one column table another column
You can create calculated columns according to measures and other calculated columns.
For example, you might create one calculated column to extract a number from a string of text, and then use that number in another calculated column.
In your answer only one number say client number will get updated.
If it is not possible can you show me how to write "GOOD" sql?
There are some restrictions on changes to calculated columns: You can change the data type for a calculated column in the same way you can change the data type for other columns.
You cannot make the following data-type changes: from text to decimal, from text to integer, from text to currency, and from text to date. The formula for a calculated column can be more resource-intensive than the formula used for a measure.
For example, a calculated column that is based on another column—or a calculation that contains an expression with a column reference—cannot be evaluated until the other column is evaluated. So, keep in mind that formula dependencies can affect performance.It then calculates the end of the month value for each row in the Promotion table.The second parameter specifies the number of months before or after the month in Start Date; in this case, 0 means the same month.By default, new calculated columns are added to the right of other columns, and the column is automatically assigned the default name of Calculated Column1, Calculated Column2, and so on.After creating columns, you can rearrange and rename columns as necessary.