Forum Discussion

DorienM's avatar
DorienM
Icon for Helper II rankHelper II
6 years ago
Solved

Consolidating two nullable date columns into a single column

I have two date columns that look like this:

EstimatedCloseDateActualCloseDate
4/19/20204/20/2020
null6/11/2020
7/18/2020null
nullnull

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:

EstimatedCloseDateActualCloseDateActionableCloseDate
4/19/20204/20/20204/20/2020
null6/11/20206/11/2020
7/18/2020null7/18/2020
nullnullnull

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])

     

3 Replies

  • DorienM ,

    Create COlumn like below:

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

     

    • DorienM's avatar
      DorienM
      Icon for Helper II rankHelper II

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