Trying to exclude date in function

Question

Hey BI Community,&nbsp;&nbsp;I may have a very simple question, but for some reason, I can not seem to find an answer to my problem. I am trying to put together a very simple formula that takes into consideration multiple columns and then outputs an expression. What I am trying to do is figure out how to list a column that will produce a "Late" text value. The formula is as follows:&nbsp;Late Open = IF(PurchaseOrdersData[Line Status] = "Open", AND(PurchaseOrdersData[Projected Date] &lt; TODAY(), PurchaseOrdersData[Projected Date] &lt;&gt; VALUE("1/1/1900")), "Late")&nbsp;I think there are some things I am missing I am sure however the important aspect of my problem is that I can't seem to figure out how to make the highlighted section work. I NEED to make sure that the date is included in the expression but I can't seem to figure out how.&nbsp;&nbsp;Any help would be greatly appreciated! Thank you!

alb · Accepted Answer

Hi Anonymous&nbsp;
Try
Late Open =
IF (
    PurchaseOrdersData[Line Status] = "Open"
        &amp;&amp; PurchaseOrdersData[Projected Date] &lt; TODAY ()
        &amp;&amp; PurchaseOrdersData[Projected Date] &lt;&gt; DATEVALUE ( "1/1/1900" ),
    "Late"
)
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers&nbsp;
&nbsp;

&nbsp;

Forum Discussion

Trying to exclude date in function

2 Replies

Related content

Exclude blanks when using the GENERATESERIES function

Drill through excluding specific record

Previous Day Function (Weekends excluded)

DATESYTD function

DAX Studio space after function name