Well, I love this channel and watch as many videos as I can to learn Power BI. As I studied this video and the DAX definition of CALENDAR, I noticed a small problem. Since the dates included in the CALENDAR function are inclusive of both the start date and end date, the Last 7 Days formula seems to actually return 8 days, the Last 28 Days formula 29 days, and so forth. So I think the fix is that the first CALENDAR argument (i) for the Last 7 Days formula should be _today - 6, (ii) for the Last 28 Days formula should be _today - 27, and so on.
Enjoy your videos, so this is not a statement to that, but the bait and switch you make us go through by signing up on Patreon to get only the newsletter and opportunities to be a paid member. I get it but it's still lame. Shouldn't have to register first to find this out. Should be transparent and clear before we go through the hassle.
Nice video, it helped me a lot! The only issue is that when you have a slicer for years (or months), for example, it adds a new value "(Blank)" which is really annoying =/
Very good tutorial. I managed to make it work on a separate file with your provided dataset, but when applying it to my real report, I get a circular dependency when trying to connect the Date filter table to my calendar dimension table.
Hi, Thanks for the custom date filter but when I use this custom date and then try for finding sales using sameperiodlastyear, it really doesn't work on this custom filter. Any tips on it please.
Hiya, so the date filter works on the calendar table with the assumption that you've got a relationship set up with your main table. Have you checked your model view if there is one?
Anyone experiancing issues with circular dependency, comment out the autocalandar section and the rest will work ! Highlight all of the calandarauto section and press crtl + / keys. In the same alltime ability you should try a different way as the calendar auto causes this circular dependency.
You absolutely lifesaver! Thank you for taking the time to write this out after figuring out a solution. I was debugging for hours until I saw this. Seriously, thanks!
I made a similar "slicer table" where I have three columns. Date (date range of the filter), Filter (name of the range), Order (sort order of the filter). Then I have it connected to my Date table, but when I use it as a slicer one of my measure that look for a total from last year same week goes blank. And when I use the slicer with Date column of the Date table it works fine. What should I do?
Hi there, does your measure use a table not connected to the Date table? It sounds like it's not connected which is why it's not being affected by the filter
Is there a way to create a drop down that includes in between dates? For example if I have the following: Last 7 days Last 30 days Year to date Spring season (03/01/2023-05/31/2023) How do I include the hard coded dates?
It a great tutorial, but unfortunately the commands you're entering aren't clear at this resolution. Please consider zooming in future videos. Thanks for putting it out.
Clever. It will be useful for reports without measures that use time intelligence. For other cases it unfortunately breaks time-intelligence. I hope Microsoft will launch their new date picker soon that lets you preset filters.
Hi, i have followed the same steps but my visual charts go blank after selecting the the options like past 7 days, 30 day or 90. Kindly suggest any solution.
Hi, how can you add the comparison of the same period before to the selected filter? For example: filter last 7 days (1/jan/2021) VS last 7 days before (25/dec/2020). And so with the other periods selected from the filter.
I got everything right but after changing the dates in custom dates slicer and going back to last 90 days the slicer is not getting disabled.appreciate your help
This is brilliant, have a question if I want to show all sales and ignore this date drop down in a table could you give me an example of a measure?? Thanks
hi i have rest api with start and end date parameter . I get the data by passing parameter from m script. What I need I want to fetch data according to selected date from slicer date. How ? Can you pls help me in this
Hi Fernan! This has been very helpful. I have a requirement where my users have the flexibility of selecting from date period and specify a date range. This video solves half of that requirement but I can't seem to combine both in one.