Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Trying to exclude date in function

Hey BI Community,    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 consid...
Need Help
  • AlB's avatar
    AlB
    5 years ago

    Hi Anonymous 

    Try

    Late Open =
IF (
    PurchaseOrdersData[Line Status] = "Open"
        && PurchaseOrdersData[Projected Date] < TODAY ()
        && PurchaseOrdersData[Projected Date] <> 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 

     

     

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous 

Try

Late Open =
IF (
    PurchaseOrdersData[Line Status] = "Open"
        && PurchaseOrdersData[Projected Date] < TODAY ()
        && PurchaseOrdersData[Projected Date] <> 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 

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

This worked perfectly thank you so very much for you help!