Creating one week filter

[Melissa]

Hi @Vsb79,

@KimC is correct you can solve that with Power Query, please look into this topic on creating a dynamic date range slicer and see if that gets you there.

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…

Should you require further assistance, provide a mock-up PBIX file along with the data.

I hope this is helpful