default calendard date not working

[Anonymous]

I have created a slicer using this logic, the requirement is  to have a detault  date that shows today + 30 days. however my logic only shows  5/2/2023 instead of 6/5/2023 . does anyone know what i need to tweak on my formular to get it to work 

CustomDateFilter = UNION(ADDCOLUMNS(DATESBETWEEN(sales[date],TODAY(),TODAY()+30),"Type","Default"),

     ADDCOLUMNS(CALENDAR(MIN(sales[date]),MAX(sales[date])),"Type","Custom"))

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please confirm there is the related date in "sales[date]" column firstly, then try below dax formula:

CustomDateFilter =
UNION (
    ADDCOLUMNS (
        DATESBETWEEN ( sales[date], TODAY (), TODAY () + 30 ),
        "Type", "Default"
    ),
    ADDCOLUMNS (
        CALENDAR ( FIRSTDATE ( sales[date] ), LASTDATE ( sales[date] ) ),
        "Type", "Custom"
    )
)

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.

[Anonymous]

This is closer to what i want , only issue is i am getting records that have blank sales date and i wnated to know if there is a way to modofiy that query to  not bring  in rows that have blank date?