How to create 30/60/90/Lifetime filter in Power BI

#Achieversdataengineering #powerbi #powerbitutorial #dax #learnpowerbi #powerbitraining #powerbitraining

In this video of Power BI Tips and Tricks, we have discussed in detail how to create a 30, 60, 90, lifetime days filter in Power BI.

You can also take a look at our previous videos on Power BI Tips & Tricks:

How to create a chart with dynamic Axis in Power BI:

How to create month over month Analysis Chart in Power BI:

[RSSwimmer]

This was an amazing instruction and just what I was looking for!

[romariodejesusariaszuniga]

you are the man, this infomation is pure goold

[seang]

I am literally working on this now and your video is a much better solution than the one I was thinking of myself. Thanks!

[pradeekb]

Excellent presentation & I used this easily in one of my projects. Thanks a lot

[Paktvlounge]

Thank you very much for this amazing, simple solution to this problem. Please keep up the good work.

[philipedesouzasantos]

Thank you so much for your "tutorial from scratch" (= really helpful

[DhanushkaDilani]

I was go through many you-tube videos. but your Video is great and very easy to understand. therefore i was able to successfully done my Trend. thanks and Good Luck.

[FITBOYGAMING]

thank u so much!! this worked 100% PERFECTLY! 2022

[Bhatt]

amazing sir... keep making for us please

[ChrisLeacock]

Great video! 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 DateTable and DateRangePeriods I get an error saying, "A circular dependency was detected." I tried creating DateTable using CALENDARAUTO, CALENDAR, making sure "Auto date/time for new files" was turned off and trying it all again, but nothing works. Any ideas?

[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?

[seang]

Question…what IF instead of Lifetime I wanted to calculate from a specific date? We relaunched our site on 5/5/22 and that would be as far back as I want to go even though we have data from before that date. So for lifetime I would want any dates from today back to 5/15/22. What Dax would you use in that case?

[AndrewBowers-gjej]

Do you know how i would create a comparison metric using this method? For Example; i want to select 30 days, have a measure for total sales in those 30 days and a measure for total sales during the 30 days prior to that?

[iira]

I have implemented this solution. Thanks for that. However, no data is reflecting when selecting from slicer. Could you pls assist

[RandyWilley-yy]

I was following the video and when I got to the part for creating DateRangePeriods table (around 7 minutes in) I get an error stating "The syntax for ')' is incorrect". I've compared my definition and it matches exactly what you show here. I'm not sure why I'm getting this error...

[Mahesh]

instead of datesbetween can we datesinperiod !

[clarafang]

Hi, It is a fantastic a way to make the lifetime filter, however I have no idea why it is not working for me when I totally follow your step, it is keep complaining the error. shows 'the syntax for ')' is incorrect. (DAX(Var last 7 days= ADDCOLOUMNS(CALCULATETABLE('DATETABLE', DATESBETWEEN('DATETABLE'[Date ]，TODAY())), "Days range", "7 days"))).' (the last 2 brackets doesn't exist on my dax, just shows by itself when it complains the error)
is that because of the version difference or other reasons?

[sureshrao]

Sir I need 30 60 90 days sale chart when I select month or date in the date and month selection how to do it.

[cloehe]

What if I wanna filter the data for next 30days, 60days, 90days? I just change the syntax from TODAY() -30 to TODAY()+30, but it doesn't work. Could you please help me?