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 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.
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
What about using bookmarks for this, so three bookmarks where you adjust the date range filter (relative date, last 30 days etc) and then add a few buttons on the page to toggle between the bookmarks
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
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.
Hi Fernan, I like the solution, but it generated a circular dependency issue when I joined back the [Period] table to the original pre-generated [Date] table. Have you found any workaround for this issue? Few other people raised this issue in the comments. Great work otherwise, thank you for your reply in anticipation..
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.
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)
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?
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.
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?
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!!!
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.
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!
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.
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 👍
U r excellent fernan I skipped this ur video last to last year..but today when I saw complete then I got to know it's importance
THANKS SO MUCH!!! YOU SAVED MY LIFEEEE
You’re very welcome Melina!
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.
to fazendo o L aqui também tentando decifrar
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
how did you change it to checkboxes and then buttons In 4:05? could you explain?
Thanks for the question Nivedha, I used the slicer visual for this!
thanks helpful, but I'm getting a circular dependency when creating the relationship between the calendar table and this one
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
Awesome! Very clever trick well done
What about using bookmarks for this, so three bookmarks where you adjust the date range filter (relative date, last 30 days etc) and then add a few buttons on the page to toggle between the bookmarks
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
Thanks a lot for sharing your knowledge with us
Very helpful, thank you
Hello,
Thank you so much. Is there a way to add QTD and YTD ?
Hi Remi, yes of course, you'll just need to add a QTD or YTD buckets in your "In the last" column, I'll see if I can cover this in my future videos!
Great video dude, thank u!
You're welcome!
Woow, Thanks alot, this is exactly what I'm looking for. Great work
Glad to hear that!
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?
Very helpful. Thank you.
You're welcome!
I tried this and on joining the tables , I got circular dependency error , why there was no error on the calculated table on circular dependency
Thank you!! It really helped me
Glad it helped!
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.
This is just beautiful
really excellent! thanks to save me!
I was suppose to do the wrong way.
You are welcome, glad it helped!
Hi Fernan, I like the solution, but it generated a circular dependency issue when I joined back the [Period] table to the original pre-generated [Date] table. Have you found any workaround for this issue? Few other people raised this issue in the comments. Great work otherwise, thank you for your reply in anticipation..
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.
How would you adapt this for Forward-looking dates as well?
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)
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?
Best video on this topic. Thanks so much sir.
Appreciate that, thanks!
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.
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?
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!!!
Excellent Video, thank you
You are welcome!
Thanks, I am watching this video in 2024 and still found out very useful.
Very helpful!
why not use switch? are there restrictions?
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.
Excellent...!!
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!
@@SolutionsAbroad Hmmmm, ok. So that separate table would filter the original Visit table.
I'll give that a try. Thx
Hello Sir. When I try to create relation b/w calendar and period, it is throwing an error "Circular Dependency. Kindly let me know.
Is this video zoomed in? I am unable to see where he is clicking on property panels on the right side of his screen.
(Error) Expression refers to multiple column, multiple coloumns cannot be converted to a scaler value.
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!
@@SolutionsAbroad hi, I tried changing today() to is filtered() and that did not work, what can i use to make this example work?
Thanks a lot
Thanks
how to restrict data in power query that has last 30/10 days or 2 months/ last quarter/last 4 or 3 weeks
I followed same. After selecting last 15 / 30 no result
Can you guide me on this
Super...
Thank you
Thanks sir
So nice of you, thanks!
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.