topic Re: DAX: How use dates in an IF function in DAX Commands and Tips

DAX: How use dates in an IF function

LABrowne — Tue, 07 Nov 2023 12:16:44 GMT

Hi there,

Am currently working on an if function and have completed most of it, please see below:

VAR = IF( [QualityCheck(%)] > 1 && Order[NumberProductsOrdered] >= 2, "Green", BLANK())

Orders have an expiry date a year after delivery. I need another condition within the logical test bit which is that DONT consider orders within 3 months of it's expiry date. Expiry date is it's own column.

Any help greatly appreciated.

Kind regards,

Luke

Re: DAX: How use dates in an IF function

FreemanZ — Tue, 07 Nov 2023 13:46:48 GMT

hi LABrowne ,

What do you mean by "DONT consider orders within 3 months of it's expiry date", or what should be return in this case?

Re: DAX: How use dates in an IF function

WinterMist — Tue, 07 Nov 2023 13:57:44 GMT

LABrowne

Please try something like the following:

VAR =

IF(

[QualityCheck(%)] > 1

&& Order[NumberProductsOrdered] >= 2

&& TODAY() < 'Table'[Expiry Date] - 90, --TODAY IS BEFORE 90 DAYS LEADING UP TO THE EXPIRY DATE

"Green",

BLANK()

)

NOTE: In this example, I used TODAY(). However, if you need to compare it to a different date (i.e. Order[Order Date]), then simply switch to the desired date.

Regards,

Nathan