Filter your data on last 30/60/90 days using this trick! // Beginners Guide to Power BI in 2021

Get Demo Files here

In this video we go through how to create a simple trick that will let you filter your data based on last x days that you choose.

-

🚩 Support us to get perks such as demo files, early access and more!

MY FAVOURITE POWER BI BOOKS

MY GEAR

GET IN TOUCH

🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of YouTube.

If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.

🐎 First, watch this video about how a typical Power BI workflow looks like

🗺 Learn DAX to extend your Power BI calculations

📆 Stay up-to-date on all the features Power BI releases monthly

🧪 Get certified as a Microsoft Data Analyst Associate

💡 Learn Power BI Features to improve your dashboards
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.

🔻 Get started with Power BI Desktop for FREE

#PowerBI #DataAnalytics #BusinessIntelligence

[Ericcartman]

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 👍

[phildanley]

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!

[namangarg]

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

[ckera]

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!

[ashybaby]

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

[joelvargas]

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.

[analyticsarena]

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

[mazjunk]

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

[julianhegedus]

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

[tiborbicsak]

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

[anushkaamtg]

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.

[melinamijares]

THANKS SO MUCH!!! YOU SAVED MY LIFEEEE

[ChrisLeacock]

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.

[alpeshpatel]

thanks helpful, but I'm getting a circular dependency when creating the relationship between the calendar table and this one

[utkarshdwivedi]

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?

[subratokumar]

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

[sathishkumar-yhmx]

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.

[remirichard]

Hello,
Thank you so much. Is there a way to add QTD and YTD ?

[sarahmapeta]

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?

[mattjones]

How would you adapt this for Forward-looking dates as well?