Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
janine_hummel
New Member

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 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. 

 

 

1 REPLY 1
greggyb
Resident Rockstar
Resident Rockstar

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
)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.