Date is greater than if formula

[TR405]

Hi, 

I am trying to filter out rows, that have

a) the Clearance date value not blank

b) the Clearance date must be after 2022-09

I tried using this formula:

Clearance date Filter = if(ISBLANK(QAR_db_31_10[Clearance date]),"DO NOT DISPLAY", if(QAR_db_31_10[Clearance date]>2022-9, "DISPLAY", "DO NOT DISPLAY"))

While it seems to be able to filter out the blank cells, it does not work for the date after 2022-09.

Could anyone please help me out?

Thanks a lot.

[v-binbinyu-msft · Accepted solution]

Hi @TR405 ,

Please try below steps:

1. below is my tets table

Table:

2. create a measure with below dax formula

Measure =
VAR cur_date =
    SELECTEDVALUE ( 'Table'[Date] )
VAR cur_year =
    YEAR ( cur_date )
VAR cur_month =
    MONTH ( cur_date )
RETURN
    IF (
        ISBLANK ( cur_date )
            || AND ( cur_year = 2022, cur_month <= 9 ),
        "Do not display",
        "Display"
    )

3. add a table visual with field and measure

Please refer the attached .pbix file.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@TR405 ,

Clearance date Filter = if(ISBLANK(QAR_db_31_10[Clearance date]),"DO NOT DISPLAY",

if(QAR_db_31_10[Clearance date]> date(2022,09,01) , "DISPLAY", "DO NOT DISPLAY"))

You can use date(2022,09,30)  if needed

Also consider switch(True() ,

Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56