Lastest 12 Weeks in a Slicer

[HariGanesan]

Hi All,

I have used our custom Date table that was populated using mquery that was posted in our EDNA platform.

I want to have Latest 4 weeks, 12 weeks, 26 weeks and 52 weeks in a slicer.
So lets say I have a visual where i show the count of products sold. I want to have this Latest 4,12,26 and 52 weeks in slicer and the data gets populated correspondingly.

I have seen a couple of posts where they have used to directly calculate some of these but i dont want to do sumx or anything rather have this in a slicer and when chosen the general measure sumx(sales) should take values for only latest 12 weeks.
Have been struggling with this for quiet some time now

Kindly help me in this regard.

Thanks,
Hari G

[Anurag]

Hi,

May you share your work in progress pbix it help form member to solve your query .

Thanks,
Anurag

[Melissa]

Hi @HariGanesan,

You can explore this technique and see if that meets your requirement.

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…

I hope this is helpful

[Rajesh]

Hi @HariGanesan

Here is the Dax Solution. You can try

Step1: Create a table like below, I created only for 4 and 12, you can add other values.

Step2: Enable bidirectional between Dates Table and Period Table.

Now we can use those values in Slicer

[EnterpriseDNA]

It’s great to know that you are making progress with your query @HariGanesan.

Please don’t forget if your question has been answered within the forum it is important to mark your thread as ‘solved’.

We request you to kindly take time to answer the Enterprise DNA Forum User Experience Survey, We hope you’ll give your insights on how we can further improve the Support forum. Thanks!

[EnterpriseDNA]

Hi @HariGanesan, due to inactivity, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.

Kindly take time to answer the Enterprise DNA Forum User Experience Survey, we hope you’ll give your insights on how we can further improve the Support forum. Thanks!

[EnterpriseDNA]

You can check out the follow up inquiries on this thread- Years Inside The Same Slicer - #2 by EnterpriseDNA