Forum Discussion

Cuorepazzu's avatar
Cuorepazzu
Copper Contributor
Oct 13, 2023
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 [dknbr] = 13371 or [dknbr] = 13484 or [dknbr] = 14914 then Date. AddDays([delivery date], -7) else Date.AddDays([delivery date], -2)
-------
which is fine until now. Now I want to add an exception or similar, that:
if dknbr = 12264 the delivery date is +2.

Does anyone have a suggestion?
Thank you!

 

 

excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Oct 13, 2023

    Cuorepazzu 

    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?

  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Oct 13, 2023

    Cuorepazzu 

    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.

  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Oct 13, 2023

    Cuorepazzu 

    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?

Resources