Only show blank dates AND dates earlier than current day.

[qwaszx55]

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.

[v-xjiin-msft · Accepted solution]

@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]
)

Thanks,
Xi Jin.