How do I get TOTALYTD from 2 different columns, depending on if one is empty or not?

[Anonymous]

Hi Community.

We have a problem with the logic for an YTD calculation. We would like the YTD depending on if a Final value column is populated or not. If Final is not populated we want to use Provisional as the value for that row. These values comes from 2 different facts that have a relation to the same Calendar. As below.

Year Month	Final	Provisional	YTD
Jan 2023	1	2	1
Feb 2023		2	3
March 2023	4	3	7
April 2023		1	8

Thank you in advance for any help

Br/M