Using relative date slicers with OFFSETS

[Schreg]

I know there must be tons of information out there on @Melissa extended date table, and video’s on how to use the offset columns, but I have yet to see a straight forward set of instructions on how to use offsets to create a range date slicer like this:

Can anyone shine a light on how I can go about linking these relative slicers to my fact table?

PBIX file:
range slicer w offsets.pbix (95.9 KB)

[DavieJoe]

Is this what you are after?

Dynamic Date Range Slicer- Query M

All, Here is a solution that I use on most of my models regarding a dynamic date range slicer. I found the solution from Chris Webb, from this blog post: I changed up his solution a bit to match the solution I wanted. In order to set this up, you’ll need 2 different sets of M code. Read the blog to understand fully how this is done, but I wanted to point out that an important feature in the setup is the Relationship between the Table and the “Date Table”, Make sure in this case to have the Cr…

[Schreg]

Thanks @DavieJoe , definitely looks like what I’m after, although at a quick glance, it doesn’t seem like its using offsets. But it may resolve my inquiry. I’ll more into it.

[DavieJoe]

I realise it doesn’t refer to your point about offsets but when I seen the image you posted of the slicer elements my immediate thought was of the link/post I provided. A very useful read.

[Schreg]

Thank you @DavieJoe !
I marked your reply as the solution, however, I noticed this causes a referential integrity issue because the Period table[rolling year] is looking back further than the start of my date table.

[DavieJoe]

Are you not able to move the date back in the date table so they start at the same time?

[Schreg]

I guess I could. There would just be a full empty year in the dataset.