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?
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?
- Thank you!
