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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper I

## Create moving range of dates with DAX

I have a dates table.  I want to set up a slicer on the dates, allowing a user to define an end-date.  From that I want to create a set period of indexed dates tied to that variable date that can be used as a filter on other measures.

As an example, if the date range is 1/1/22 to 1/31/22, and a user selects 1/31/22 with the slicer, and the rolling period is set to 7 days, I want the dates from 1/31/22 back to 1/24/22 to be indexed as a '1' and all the other dates in the range to be a '0'; if they select 1/20/22, the index would be from 1/20/22 back to 1/13/22, and all other dates would be '0'.  Thus if I have DAX measures that are tied to dates, and I apply this moving indexed range as a filter, what would be displayed would only be the measures associated with the dates in that range.  Any suggestions?

1 ACCEPTED SOLUTION
Super User

Hi,

Please check the below picture and the attached pbix file.

``````Index measure: =
IF (
MAX ( Data[Date] ) <= MAX ( Slicer[Date] )
&& MAX ( Data[Date] )
>= MAX ( Slicer[Date] ) - 7,
1,
0
)
``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Go to My LinkedIn Page

2 REPLIES 2
Super User

Hi,

Please check the below picture and the attached pbix file.

``````Index measure: =
IF (
MAX ( Data[Date] ) <= MAX ( Slicer[Date] )
&& MAX ( Data[Date] )
>= MAX ( Slicer[Date] ) - 7,
1,
0
)
``````

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Go to My LinkedIn Page

Helper I

yep, that solution worked... thank you so much! 😉

## Helpful resources

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors