Forum Discussion
Solved
Power Query Code
Hello I have the following code: if [dknbr] = 13015 or [dknbr] = 13391 or [dknbr] = 13413 or [dknbr] = 13022 or [dknbr] = 13401 or [dknbr] = 13048 or [dknbr] = 13311 or [dknbr] = 13420 or [dknb...
if [dknbr]= 12264 then Date.AddDays([delivery date], 2)
else if [dknbr] = 13015 or [dknbr] = 13391 or [dknbr] =
13413 or [dknbr] = 13022 or [dknbr] = 13401 or [dknbr] =
13048 or [dknbr] = 13311 or [dknbr] = 13420 or [dknbr] =
13371 or [dknbr] = 13484 or [dknbr] = 14914 then
Date.AddDays([delivery date], -7)
else Date.AddDays([delivery date], -2)Does this work in your Power Query Editor as well?
As variant
if [dknbr]= 12264
then Date.AddDays([delivery date], 2)
else
if List.Contains({13015, 13391, 13413, 13022, 13401, 13048, 13311, 13420, 13371, 13484, 14914 }, [dknbr])
then Date.AddDays([delivery date], -7)
else Date.AddDays([delivery date], -2)
Even more better if don't hardcode dknbr conditions in formula, but create separate list for that which use in criteria.