IF function with date range and one additional condition

[anettpb]

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!

[JadhavVarsha_13]

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]

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.

[v-rzhou-msft · Accepted solution]

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]

Hello @v-rzhou-msft 

Thanks a lot, it is worked well 🙂