Replace null with value from another column

Question

Hi Everyone,&nbsp;I have a table that looks like this.&nbsp;Date Finished&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Date Closed&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Date Diff&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12/02/2019&nbsp;06/02/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10/02/2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0702/2019&nbsp;How I want to create a new column to replace the null in [Date Finished] with the value in [Date Closed], the DAX that I tried doesn't work. How should I possible fix this? Thank you!&nbsp;&nbsp;New Column = 
IF (
    ISBLANK ( [Date Finished] ), [Date Closed], [Date Finished]
)&nbsp;

ashish_mathur · Accepted Answer

Hi,
&nbsp;
That calculated column formula is correct.&nbsp; May thereare some invisible characters/spaces in the Date Finished column.

Forum Discussion

Replace null with value from another column

1 Reply

Related content

Replace null values of one column to another column.

Query editor replacing values based on another column

How to replace one column value with another column value from another table?

Replace null values with contents from another column

Replace value with value from another column?