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

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors