How to put the value in only blank column?

[saranp780]

My requirement is to add data into the blank row. My data is

Creation date	Creation from system	Deleting
12/5/2016	12/5/2016
	13/5/2016
	14/5/2016
15/1/2016		15/6/2017
16/1/2016		16/6/2017
16/1/2016		17/6/2017
	12/4/2017
	13/4/2017
	14/4/2017
16/1/2016		16/4/2018
	12/2/2017
	12/2/2017
	12/2/2017
	12/2/2017
	12/2/2017
	12/2/2017

Creation date(In the first column) is from manual adding. We can't collect some data so we need to get the date from the system. (Second column) We found more data but something has deleted from the system then we lose some data too.  So we want to merge the data that empty from the system to get all of the data (Not merge). Like in the picture

And this is the result.

Creation date	Creation from system	Deleting
12/5/2016	12/5/2016
	13/5/2016
	14/5/2016
15/1/2016	15/1/2016	15/6/2017
16/1/2016	16/1/2016	16/6/2017
16/1/2016	16/1/2016	17/6/2017
	12/4/2017
	13/4/2017
	14/4/2017
16/1/2016	17/1/2016	16/4/2018
	12/2/2017
	12/2/2017
	12/2/2017
	12/2/2017
	12/2/2017
	12/2/2017

Can I do this in Power BI? Could you please suggest me hot to do this in DAX?

Thank you all.

[v-piga-msft · Accepted solution]

Hi @saranp780,

You could create a calculated column with the formula below.

Column 2 =
'table'[Creation from system]
    & IF ( ISBLANK ( 'table'[Creation from system] ), 'table'[Creation date] )

Here is the output.

Hope this can help you!

Best  Regards,

Cherry