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.
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.
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
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!
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.
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
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
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, 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?
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.
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.
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.
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
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.
Thanks!
I appreciate the generosity, thank you so much!
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.
Great explanation as always... How can we add the last 5 year in date filters
Thanks
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 =/
Phenomenal video Fernan! Really underrated channel!
I’ve been looking for exactly this for a while now. Thank you!!
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.
Wow, that was awesome. Thanks for sharing your knowledge with the community!
Hard skills but with a simple idea.
Best.
Glad you liked it!
Excellent tutorial!!! It worked like a magic.
Excellent, this was exactly what I needed.
This is exactly what I was looking for. Thanks!
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
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!
Fantastic Video Fernan- this is a Client request that I've had before- great solution!
Best,
James- Matador Software
Hey James, thanks for watching and glad it helped!
omg this is wat i was looking for u are the best sir thank you so much
While writing DAX, it will be better if show DAX in focus mode. Because DAX is showing small font. Can't see properly.
Thanks for the feedback!
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?
Awesome! Many thanks for sharing this information!
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.
Maybe add a traditional date “Between” slicer above what he just showed?
Thanks, this was very useful
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
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
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.
Thanks Boss
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?
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.
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?
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.
Thanks, very useful
Hi @solutoin please let me know how we can add mtd YTD and qtd as well
I cant add the date range in the text box. It cant find the measure I've created. So frustrating.
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?
Hello,
How can we set FILTER if we have to Exclude SATURDAY & SUNDAY? @Solutions Abroad
how can i do this for current quater
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?
How can I add "This Year" as the whole of 2021?
I did this but it broke a bunch of measures that I was using my Date Table for any thoughts on why?
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 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
Sir how can we make it tabular form for a different data tody, yesterday,last 7 days, etc. ?
Hi Akshay, what type of tabular data are you trying to generate? just the dates? If so just drag the dates into a table visual!
for some reason I can't get the order to work properly
Superb😊😊😊
Can you do next 30, 90 and 120 days please, not minus 🙂
This is what I need too!
@@RachelTamez I did this way: ,ADDCOLUMNS (
CALENDAR(_today ,_today +7),"Filter","Next 7 Days". It works. 🙂
❤❤❤❤❤❤❤❤
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.
Please make short tutorials not more than 8 min each.
Please try to follow KISS rule for making tutorials.
Appreciate the feedback, I'll keep that in mind next time!
Use Less unable to see the content.