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'[Document Date]=2023.02.13 OR 2023.02.14),"Pre-order","Ad-hoc")

 

Thanks a lot!

 
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.

4 Replies

  • 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.