cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Only show blank dates AND dates earlier than current day.

Just when I start thinking I'm getting a grasp on using PowerBI I run into another stupid problem that stumps me.

 

I have a table full of end dates for projects. Some of them however are blank.

 

If I wanted a column to show the blank dates AND those dates whose end date has already passed what would be formula?

 

I played with it for a while and got this but it isn't working.

 

Date2 = if (PROJECTS[ENDDATE] = blank() || TODAY() < PROJECTS[ENDDATE]), PROJECTS[ENDDATE])

 

As always thanks for your help.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Solution Sage
Solution Sage

Re: Only show blank dates AND dates earlier than current day.

@qwaszx55

 

In your scenario, you want create a column to display the EndDate which is blank or earlier than current day. Right?

 

To achieve your requirement, you can try following expression:

 

Column =
IF (
    OR ( PROJECTS[ENDDATE] = BLANK (), TODAY () > PROJECTS[ENDDATE] ),
    PROJECTS[ENDDATE]
)

11.PNG

 

Thanks,
Xi Jin.

View solution in original post

1 REPLY 1
Highlighted
Solution Sage
Solution Sage

Re: Only show blank dates AND dates earlier than current day.

@qwaszx55

 

In your scenario, you want create a column to display the EndDate which is blank or earlier than current day. Right?

 

To achieve your requirement, you can try following expression:

 

Column =
IF (
    OR ( PROJECTS[ENDDATE] = BLANK (), TODAY () > PROJECTS[ENDDATE] ),
    PROJECTS[ENDDATE]
)

11.PNG

 

Thanks,
Xi Jin.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors