Forum Discussion

PeteyG's avatar
PeteyG
Icon for Helper I rankHelper I
2 years ago
Solved

IF isBlank on multiple columns return first nonblank date.

Hello all-

 

I am trying to create a new column called in this example "Issued Date"  What I need it to do is look back at Date4 and if it has a date put that date in.  If blank look at date3.  If it has a date return that one otherwise going to Date2 and so on.  I can do it between two columns but as soon as I add a third and forth I get two many arguments errors.  Anyone have a work around?

 

 

ItemDate1Date2Date3Date4Issued Date
item1  9/29/2021  12/21/2022  9/12/2023   9/12/2023
item29/29/2021  12/21/2022  9/12/2023  5/29/2024  5/29/2024
item39/29/2021     9/29/2021
item49/29/2021  12/21/2022  9/12/2023 5/29/2024  5/29/2024
item59/29/202  12/21/2022    12/21/2022
item69/29/2021     9/29/2021
item79/29/2021  12/21/2022  9/12/2023   9/12/2023
item89/29/202112/21/20229/12/20235/29/20245/29/2024

 

  • PeteyG you can try something like this:

     

    Issued Date = 
    COALESCE ( Table[Date4], Table[Date3], Table[Date2], Table[Date1] )
    

3 Replies

  • PeteyG you can try something like this:

     

    Issued Date = 
    COALESCE ( Table[Date4], Table[Date3], Table[Date2], Table[Date1] )
    
    • PeteyG's avatar
      PeteyG
      Icon for Helper I rankHelper I

      That was perfect!  I can not believe how much time I spent on nested if statments to not work.  Thanks so much!