Forum Discussion

janine_hummel's avatar
janine_hummel
New Member
10 years ago

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

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 visu...
greggyb's avatar
greggyb
Resident Rockstar
10 years ago

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
)