Forum Discussion
DorienM
Helper II
6 years agoConsolidating two nullable date columns into a single column
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.
DorienM ,
Create COlumn like below:
Third COlumn = IF(Table[ActualCLoseDate]=BLANK(),Table[EstimatedClosedDate],Table[ActualClosedDate])