Forum Discussion
Solved
DAX: How use dates in an IF function
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()) ...
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
