Consolidating two nullable date columns into a single column

[DorienM]

I have two date columns that look like this:

EstimatedCloseDate	ActualCloseDate
4/19/2020	4/20/2020
null	6/11/2020
7/18/2020	null
null	null

I would like to create a third column either in the query or afterwards called ActionableCloseDate which prefers the ActualCloseDate but uses the EstimatedCloseDate if the ActualCloseDate is null. Ideally it would look like this afterwards:

EstimatedCloseDate	ActualCloseDate	ActionableCloseDate
4/19/2020	4/20/2020	4/20/2020
null	6/11/2020	6/11/2020
7/18/2020	null	7/18/2020
null	null	null

I am a bit of a PowerBI noob so theres a good chance this is pretty simple but I have no idea where to start. Any help would be greatly appreciated.

[Tahreem24 · Accepted solution]

@DorienM ,

Create COlumn like below:

Third COlumn = IF(Table[ActualCLoseDate]=BLANK(),Table[EstimatedClosedDate],Table[ActualClosedDate])

[DorienM]

Wow that is way simplier than I thought it would be. Thanks it is working great.

[Tahreem24]

@DorienM ,

Gald that I helped you!

Good Luck!