Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

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 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:

 

Late Open = IF(PurchaseOrdersData[Line Status] = "Open", AND(PurchaseOrdersData[Projected Date] < TODAY(), PurchaseOrdersData[Projected Date] <> VALUE("1/1/1900")), "Late")
 
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. 
 
Any help would be greatly appreciated! Thank you!
1 ACCEPTED SOLUTION
AlB
Community Champion
Community Champion

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 

 

SU18_powerbi_badge

 

View solution in original post

2 REPLIES 2
AlB
Community Champion
Community Champion

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 

 

SU18_powerbi_badge

 

Anonymous
Not applicable

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.