Help with IF multiple if statements

[Anonymous]

I have 4 columns with different values. I need a function that:

IF Column Value1 is empty, take Column Value2, and if this one is empty, take Column Value3, and if that one is empty, take Column Value4.

Can someone help me express this with IF statements or Switch?

Thank you!

[Candlewing2]

This is perfect! Many thanks, Ashish! 🙂

[Ashish_Mathur]

You are welcome.

[Ashish_Mathur · Accepted solution]

Hi,

Try this calculated column formula

=if(isblank(Data[Column1]),if(isblank(Data[Column2]),if(isblank(Data[Column3]),Data[Column4],Data[Column3]),Data[Column2]),Data[Column1])

[jhoyabel19]

Hi @Ashish_Mathur , I have the same problem but the formula is not working

I want to create a calculated column where

• If Column 1 is blank get the date from
• Column 2 but if this is blank get the dates from
• Column 3 but if this is blank get the dates from
• Column 4
  
  This is my data and the final dates is the Calculated column i want as outcome

Offer Accepted	Offer Accepted (On Boarding)	Accepted forms reviewed	Forms completed	Accepted Forms completed Pending Review	Final Dates
07/02/2022					07/02/2022
18/02/2022					18/02/2022
23/02/2022					23/02/2022
23/02/2022					23/02/2022
Blank	11/03/2022				11/03/2022
Blank	11/03/2022				11/03/2022
Blank	11/03/2022				11/03/2022
Blank	Blank	11/05/2022			11/05/2022
Blank	Blank	11/05/2022			11/05/2022
Blank	Blank	11/05/2022			11/05/2022
Blank	Blank	Blank	24/02/2022		24/02/2022
Blank	Blank	Blank	Blank	05/04/2022	05/04/2022

[Ashish_Mathur]

hi,

It is easier to solve this in the Query Editor.  This M code works

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Offer Accepted", type date}, {"Offer Accepted (On Boarding)", type date}, {"Accepted forms reviewed", type date}, {"Forms completed", type date}, {"Accepted Forms completed Pending Review", type date}}),
    Custom1 = Table.AddColumn(#"Changed Type","Final date", each List.Min(Record.ToList(_)), type date)
in
    Custom1

Hope this helps.

[jhoyabel19]

@Ashish_Mathur Thank you. Can i do this as custom column as in my other table i have other columns as well

[Ashish_Mathur]

Hi,

See if this M code works

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Offer Accepted", type date}, {"Offer Accepted (On Boarding)", type date}, {"Accepted forms reviewed", type date}, {"Forms completed", type date}, {"Accepted Forms completed Pending Review", type date}}),
    Custom1 = Table.AddColumn(#"Changed Type","Final date", each List.Min(List.Skip(Record.ToList(_),2)), type date)
in
    Custom1

[jhoyabel19]

Thank you. It worked, You're a saviour 🙂

[Ashish_Mathur]

You are welcome.  Please mark my previous reply as Answer.