Time Intelligence: How to create a time range between dynamic dates?

[janine_hummel]

Hey guys, 

for a visualisation, I'm trying to set a time range for 10 days. This range is supposed to refresh itself as the days go by, showing only the last 10 days of the data table in the visualisation. 

I tried to accomplish this using the DATEBETWEEN function, with TODAY()-1 and TODAY()-10 as the date range. Unfortunately, DATEBETWEEN function won't allow using the TODAY parameter for this. 

Do you guys have an idea how to solve this problem? Right now, the visualisation is modified with a static date filtre which has to be renewed every day. 

[greggyb]

DATESBETWEEN() certainly allows TODAY() with arithmetic as an argument. What error are you seeing when you try this?

DATESBETWEEN() does require a proper date dimension with consecutive, non-repeating dates.

// DAX
// fragment

DATESBETWEEN(
    DimDate[Date]
    ,TODAY() - 10
    ,TODAY() - 1
)