default calendard date not working

Question

I have created a slicer using this logic, the requirement is&nbsp; to have a detault&nbsp; date that shows today + 30 days. however my logic only shows&nbsp; 5/2/2023 instead of 6/5/2023 . does anyone know what i need to tweak on my formular to get it to work&nbsp;CustomDateFilter = UNION(ADDCOLUMNS(DATESBETWEEN(sales[date],TODAY(),TODAY()+30),"Type","Default"), &nbsp; &nbsp; &nbsp;ADDCOLUMNS(CALENDAR(MIN(sales[date]),MAX(sales[date])),"Type","Custom"))

anonymous · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
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"
    )
)

&nbsp;
Best regards,Community Support Team_Binbin YuIf this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

default calendard date not working

2 Replies

Related content

DeltaTable.forName Doesn't work outside of default schema

DeltaTable.forName Doesn't work outside of default schema

Default Summarization Not Working

Slicer default selection

Powerbi Default view