IF Formula in Power Query

[orhanceliloglu]

Hi Everyone,

I have a complex IF formulas in Power Query (complex for me)

I have 4 columns >> Date1 - Date2 - Date3 - Date4

If Date3 is equal to certain exact date, I want to take Date4 without any question. But if not, then I want to go and check Date1 and Date2. There the condition is, if Date1 is null then take Date2. Else take Date1.

Should I use AND or something else?

if ([Date3] = "1/1/1111" then
Date.AddYears([Date4],+1)
else if ([Date1] = null then Date.AddYears([Date2],+1)
else Date.AddYears([Date1],+1)


When I used above formula, its taking Date2, although Date3 = 1/1/1111

PS: in example Date1 = null

Thanks
Orhan

[Norie]

Orhan

If Date3 has actual date values in it then I don't think comparing it to the string '1/1/1111' is going to work.

Is '1/1/1111' definitely the 'date' you want to check Date3 for?

[Olly]

Give us a sample of your data, with your expected outcome.