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.

I’ve been looking for exactly this for a while now. Thank you!!

This is exactly what I was looking for. Thanks!

Awesome! Many thanks for sharing this information!

Excellent, this was exactly what I needed.

Wow, that was awesome. Thanks for sharing your knowledge with the community! Hard skills but with a simple idea. Best.

Excellent tutorial!!! It worked like a magic.

Fantastic Video Fernan- this is a Client request that I've had before- great solution! Best, James- Matador Software

omg this is wat i was looking for u are the best sir thank you so much

Thanks, this was very useful

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 =/

Thanks, very useful

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.

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.

Great explanation as always... How can we add the last 5 year in date filters Thanks

Thanks!

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.

Wow, this is perfect. i want to know how to create a period from Current week "first day in week" & 5 weeks in advance "last day in 6th week?

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

Superb😊😊😊

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, 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.

Hi @solutoin please let me know how we can add mtd YTD and qtd as well

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

While writing DAX, it will be better if show DAX in focus mode. Because DAX is showing small font. Can't see properly.

how do we lock table on last day data and chart reflecting past 10 days stacked line chart data for each element on the tABLE?

My measures work if I select a date range such as last 7 days. But it they show blank if I select one day such as today or yesterday. Any idea?

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.

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?

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.

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?

how can i do this for current quater

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

I did this but it broke a bunch of measures that I was using my Date Table for any thoughts on why?

Hello, How can we set FILTER if we have to Exclude SATURDAY & SUNDAY? @Solutions Abroad

How can I add "This Year" as the whole of 2021?

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.

for some reason I can't get the order to work properly

Sir how can we make it tabular form for a different data tody, yesterday,last 7 days, etc. ?

Can you do next 30, 90 and 120 days please, not minus 🙂

Please make short tutorials not more than 8 min each. Please try to follow KISS rule for making tutorials.

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.

Use Less unable to see the content.