dbt-sqlserver 1.7.2 incremental model adding existing records with different version

The problem I’m having

creating a incremental model that appends records to the target table and if they exists then update the version_number + 1 without deleting the existing records for this date

The context of why I’m trying to do this

because i want to see the history of the given date what is changed on this given referenced date. If I already have records on the target table lets say on 2024-02-18 with version==1

Then I would like to append the incoming records on the same date but with max(version) + 1

Thanks a lot, maki.markie