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.
@user-ze3gd3yp9g19 күн бұрын
Phenomenal video Fernan! Really underrated channel!
@tomkochka20589 ай бұрын
I’ve been looking for exactly this for a while now. Thank you!!
@jeffersonramos57262 жыл бұрын
Wow, that was awesome. Thanks for sharing your knowledge with the community! Hard skills but with a simple idea. Best.
@SolutionsAbroad2 жыл бұрын
Glad you liked it!
@Yogesh.Suryavanshi Жыл бұрын
Great explanation as always... How can we add the last 5 year in date filters Thanks
@joserobertodantas1516 Жыл бұрын
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 =/
@MatadorSoftware2 жыл бұрын
Fantastic Video Fernan- this is a Client request that I've had before- great solution! Best, James- Matador Software
@SolutionsAbroad2 жыл бұрын
Hey James, thanks for watching and glad it helped!
@Vpatel1698 ай бұрын
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
@zubairshimon985 Жыл бұрын
Excellent tutorial!!! It worked like a magic.
@logiman Жыл бұрын
This is exactly what I was looking for. Thanks!
@sst-music Жыл бұрын
Excellent, this was exactly what I needed.
@QuantumIdeas Жыл бұрын
Thanks!
@SolutionsAbroad Жыл бұрын
I appreciate the generosity, thank you so much!
@simeontodorov9353 Жыл бұрын
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.
@sunandamadhuri935510 ай бұрын
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
@Rajesh-gw7di7 ай бұрын
omg this is wat i was looking for u are the best sir thank you so much
@jordansmith92306 ай бұрын
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.
@user-ze3gd3yp9g19 күн бұрын
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!
@ItsWithinYou2 жыл бұрын
Awesome! Many thanks for sharing this information!
@martingoedhart22946 ай бұрын
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.
@ramyhus2 жыл бұрын
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?
@MattJohnson2469 Жыл бұрын
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.
@RowellLagman-ht1qg Жыл бұрын
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.
@tomkochka20589 ай бұрын
Maybe add a traditional date “Between” slicer above what he just showed?
@JamesFujitsu Жыл бұрын
Thanks, this was very useful
@sujithavvari12 күн бұрын
Thanks Boss
@Learnerpro1232 жыл бұрын
While writing DAX, it will be better if show DAX in focus mode. Because DAX is showing small font. Can't see properly.
@SolutionsAbroad2 жыл бұрын
Thanks for the feedback!
@HennessysXO Жыл бұрын
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?
@KedielSanchezMariano2 жыл бұрын
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?
@SolutionsAbroad2 жыл бұрын
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
@shahbhavin19885 ай бұрын
Hello, How can we set FILTER if we have to Exclude SATURDAY & SUNDAY? @Solutions Abroad
@bardock81 Жыл бұрын
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.
@SolutionsAbroad Жыл бұрын
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?
@fragosof Жыл бұрын
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.
@bestofUS_9010 ай бұрын
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?
@PatrickSupanich8 ай бұрын
I did this but it broke a bunch of measures that I was using my Date Table for any thoughts on why?
@divyanshhanda6492 Жыл бұрын
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.
@thembeladaphula48355 ай бұрын
How can I add "This Year" as the whole of 2021?
@sahuanalogchannel2 жыл бұрын
Hi @solutoin please let me know how we can add mtd YTD and qtd as well
@sankalpparmar41622 жыл бұрын
Thanks, very useful
@kennguyen80382 жыл бұрын
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?
@sharmadiw Жыл бұрын
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
@jatinjoshi5933 Жыл бұрын
how can i do this for current quater
@akshay99vn2 жыл бұрын
Sir how can we make it tabular form for a different data tody, yesterday,last 7 days, etc. ?
@SolutionsAbroad2 жыл бұрын
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!
@gopyjs62162 жыл бұрын
Superb😊😊😊
@popp22300 Жыл бұрын
Can you do next 30, 90 and 120 days please, not minus 🙂
@RachelTamez11 ай бұрын
This is what I need too!
@glhuanto7 ай бұрын
@@RachelTamez I did this way: ,ADDCOLUMNS ( CALENDAR(_today ,_today +7),"Filter","Next 7 Days". It works. 🙂
@shivkumaryadav-vv2iw9 күн бұрын
❤❤❤❤❤❤❤❤
@tomkochka20589 ай бұрын
for some reason I can't get the order to work properly
@abbasthegreat5 Жыл бұрын
Please make short tutorials not more than 8 min each. Please try to follow KISS rule for making tutorials.
@SolutionsAbroad Жыл бұрын
Appreciate the feedback, I'll keep that in mind next time!
@ChrisSmithFW2 ай бұрын
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.