Dax Column - Copy Date from a defined column and IF blank... copy date from another defined column

[MattSh0tt0n]

Hi all, 

My first time posting and I'm new to PBI, so apologies if this is a little unorganized.

Below is a snapshot of my data table. 

The outcome I am looking for is to show in the "Date of Activity Logged - Copy" Column the "Date of Status Change" date for this row and IF this is blank... to show the "Date of Activity Logged" date for the same row within the "Date of Activity Logged - Copy" also.

Unfortunately the source of this dataset splits these two dates into different cells, when the preferred outcome is that only the most recent date of the two is shown in a column... if that is a different way to view the issue? 

Any help on this is appreciated. 

Many thanks

Matt

[vicky_ · Accepted solution]

Try going back into PowerQuery and instead of duplicating the column, use a formula to add a new column.

= Table.AddColumn(Custom1, "NewColumnName", each if [Date of Status Change] = "" then [Date of Activity Logged] else [Date of Activity Logged])

I'm not sure where the most recent of the two dates fits in, but you can use List.Max({[Date of Status Change]}&{[Date of Activity Logged]}) to adjust the formula above if I missed something.