Forum Discussion

anettpb's avatar
anettpb
Helper I
3 years ago
Solved

IF function with date range and one additional condition

Hi All,   I would like to create a column, where I want to write whether it is Pre-order or an ad-hoc. Can anyone help me how can I do that? = IF(( 'Full data'[Delivery block]="DA" AND 'Full data...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi anettpb ,

     

    If you want to create a calculated column, you can try this code.

    Column =
IF (
    AND (
        'Full data'[Delivery block] = "DA",
        OR (
            'Full data'[Document Date] = DATE ( 2023, 02, 13 ),
            'Full data'[Document Date] = DATE ( 2023, 02, 14 )
        )
    ),
    "Pre-order",
    "Ad-hoc"
)

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

JadhavVarsha_13's avatar
JadhavVarsha_13
Helper V
3 years ago

Hello anettpb 

You can try this, Add new column.

Column Name = IF(AND(OR('Full data'[Document Date]=2023.02.13 OR 2023.02.14)),'Full data'[Delivery block]="DA")"Pre-order","Ad-hoc")

Hope this helps !

  • anettpb's avatar
    anettpb
    Helper I
    3 years ago

    Hello JadhavVarsha_13 

     

    Thanks a lot, I tried it, but it dropped syntax error.

    I forgot to mention that would needed at a matrix, I do not know that it is matter or not.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi anettpb ,

       

      If you want to create a calculated column, you can try this code.

      Column =
IF (
    AND (
        'Full data'[Delivery block] = "DA",
        OR (
            'Full data'[Document Date] = DATE ( 2023, 02, 13 ),
            'Full data'[Document Date] = DATE ( 2023, 02, 14 )
        )
    ),
    "Pre-order",
    "Ad-hoc"
)

       

      Best Regards,
      Rico Zhou

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • anettpb's avatar
        anettpb
        Helper I
        3 years ago

        Hello Anonymous 

         

        Thanks a lot, it is worked well 🙂