Forum Discussion
Calculate table and replace values based on another table
Hi,
I have a following source table:
| Contract ID | Start Date | End Date | Value |
| A1 | 2020-12-01 | 2021-12-31 | 100 |
| A2 | 2021-03-01 | 2022-12-31 | 200 |
| A3 | 2021-05-01 | 2023-12-31 | 300 |
I'm trying to create a calculated table with contracts, which expire before 2023-01-01 and at the same time Start Date and End Date will change to Expiry Date plus 1 day, so in results I'll get:
| Contract ID | Start Date | End Date | Value |
| A1 | 2022-01-01 | 2022-12-31 | 100 |
| A2 | 2023-01-01 | 2023-12-31 | 200 |
I know how to create calculated table:
CALCULATETABLE (
'tblContractList',
'tblContractList'[End Date] < DATE ( 2023, 01, 01 )
)
But how to replace the values in Start Date column in calculated table based on values from End Date column from the source table?
