DAX: Making a new column by replacing one columns blanks with another columns values.

[George_H]

Hi all 

I would like to create a new coulmn based if column A is blank it will return a date from coulmn B. If column A has a date it will return itself. 

So for example I should get a result like this:

A		B		C
01/01/2022		31/12/2021		01/01/2022
		02/01/2022		02/01/2022
		03/01/2022		03/01/2022
04/01/2022		03/02/2022		04/01/2022
		04/02/2022		04/02/2022
		05/02/2022		05/02/2022
		06/02/2022		06/02/2022
22/05/2022		07/02/2022		22/05/2022

Thanks!

[Jihwan_Kim · Accepted solution]

Hi,

Please try the below to create a new column.

C column =
IF ( 'TableName'[A] <> BLANK (), 'TableName'[A], 'TableName'[B] )

[George_H]

Yes! Thank you, I didn't think it would be that easy. I was over complicating it.