Take values of two columns in one new column (new measure)

[Anonymous]

Dear Power BI community,

I am seeking for your support regarding the following question:

I have two columns:

* Column 1 with actual sales

* Column 2 with budget sales

* Both stored in a table showing these values per week

I want to create a third column (Column 3 - Calculated Sales) as a new measure which should contain the value per week from column 1. If this column does not have a value, the value should be taken from column 2. 

Can someone help me with the DAX formula to be used? 

Below a screenshot of the desired output:

Thanks in advance for any suggestion. 

[Fowmy · Accepted solution]

@Anonymous 

You can add as a Column 

Calculated Sales= IF( ISBLANK(Table[Actual Sales]) , Table[Budget Sales] , Table[Actual Sales])

[Fowmy · Accepted solution]

@Anonymous 

You can add as a Column 

Calculated Sales= IF( ISBLANK(Table[Actual Sales]) , Table[Budget Sales] , Table[Actual Sales])

[Anonymous]

Thanks. Can this also be done as a new measure?

[Fowmy · Accepted solution]

@Anonymous 

Yes, possible

Calculated Sales= IF( ISBLANK(max(Table[Actual Sales])) , max(Table[Budget Sales]) , max(Table[Actual Sales]))