Thank you so much! Your presentation was deliberately paced and you showed all of your DAX in a legible manner. I appreciate that! And it solved by issue. Rolling 30, 60 and 90 dayfilter is successful!
Very helpful - did exactly what I needed. Well explained - I actually understand the process which is the ultimate when being taught a new trick. Thank You for taking the time to upload this 👍
I realize this video is almost a year and a half old, but it's the only one that helped me figure out how to accomplish this filtering. But no matter what I do, when I try to create a relationship between the Calendar and Periods table I get an error saying, "A circular dependency was detected." Any ideas? I tried using CALENDARAUTO and then just CALENDAR.
Thanks a lot for this solution. I got a problem in slicer label ordering. In my solution, it shows in this order last 12, last 6, last 3. How can I sort this in the correct order? Thank You
This is exactly what I was looking for! Thank you very much! Can you please explain how can I do this if I need to show "Last 3 months", Last 6 months" and "Last 9 months" ?? Thanx in advance!
Thanks a lot for this amazing solution. Is there anyway we can also show the dates? Let's say, when we select the 30 days filter, there should be dates displayed which are included in this filter. e.g from date - to date
I enjoy your videos. I have a question. I am trying to make a table that compares yesterday, last 7 days, last 28 days compared to same period last year. I can do this is Tableau no problem but this division in my company uses PowerBI. The excel has dates from jan 22 to yesterday and we have two measures to include. Number of Incidents and number of actions which is a number in the same row. They also want to see number difference and % difference.
I wanted to create a 30 60 90 table but show 30 60 90 at the bottom of the table, like at work. They are using a bubble chart, which shows the number of unpaid invoices.
Helpful video...however being new to Power BI, i wonder why would we want to do this instead of using the filter function on the right hand menu where we can achivee this with more flexibility and less effort? I would like to understand when and why we pick one approach over the other. Thanks
Ok, so this question might have an extremely simple answer but I think I'm overthinking it. I want to show stores in my region that HAVE NOT been visited in the last 30/60/90 days. The tricky part is that stores are visited multiple times by my sales team, but so sometimes a store can have a visit date of 30 days ago, 65 days ago and 70 days ago. I only want it to show up in the first group, since that is the latest visit date.
Hi Peter, it sounds like you need a separate table that outlines what counts as the "first group" is it a specific group of people, or just groups that visited at a specific time period? All you have to do at that point once you've defined the group, is to exclude all other visits from your CALCULATE DAX measure Not sure if that helped, let me know!
Hi,. This video is super useful for me. But how can I create a table, incase of a fiscal year. Can you provide a solution for financial year April to march.
Thank you for sharing your knowledge with us. This is very helpful. I wonder, while having the last N days filter, can we display the last N days before that period? Let's say if I click the last 10 days, I want to display the last 10 days value and the last 10 days before that period. Appreciate if you could help me with this.
Column =(Between current date - 60 and current date -30). I need a dax for the above condition here the current date means today's date . I need my data to change everyday . I need to use that Column in the page level filter .Any suggestion?
Thank you ! If i want my chart to still show months with no data how do i do this please? eg if I select 90 days for this period and September has no data but i still want it to show on the chart as 0, How can i do this?
Please help. I want to make the default day in powerbi to current month, but still give the user a "between" filter. So the Between filter's default value will be the current month but user can still change it anytime. Is it doable? Please advise!!!
Hi Matt, you'd still follow the same steps, the only difference is to invert the minuses into pluses (i.e. the DATESBETWEEN in the Period measure needs to be TODAY + 30 days)
Problem with this approach is the last 30 days or last 60 days buckets wont calculate from the date of selection...these are static..these buckets should change dynamically from the date of selection..i have requirement where these should change as per the selected date (order date in my case)
Hi Raghu, thanks for the feedback! You can totally do that with a few tweaks, in the DAX formula, you can simply replace the parameter TODAY() with your dynamic selection Hope that helps!
DON'T EVER USE THIS METHOD unless you want to calculate MOM / YOY values. This type of period filtering is not the same as filtering the date on the slicer with the RELATIVE DATE option.