Forum Discussion
Help with IF multiple if statements
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 ...
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])
Ashish_Mathur Thank you. Can i do this as custom column as in my other table i have other columns as well
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
Custom1Thank you. It worked, You're a saviour 🙂
You are welcome. Please mark my previous reply as Answer.