cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ajaygajree1
New Member

Filter Date for Last 7 Days of Data

Hi All

 

How can I filter my query for the last 7 days of data, so not from the current days but simply the last 7 days that is in the data?

 

Hope that makes sense!

 

Thanks in advance!

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@ajaygajree1 

You need to add a new step as follows:

Click on the Fx button on the last step

Fowmy_0-1638276315356.png

Past this code and modify the #"Changed Type" to your previous step, 

= Table.SelectRows(#"Changed Type", let latest = List.Max(#"Changed Type"[Date]) in each ([Date] <= latest) and ([Date] >= Date.AddDays(latest,- 7) ))

 

Fowmy_1-1638276385817.png



 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

3 REPLIES 3
mahoneypat
Super User
Super User

In case the dates are not consecutive, you can use this approach.  Add any filter step on your Date column and then modify it in the formula bar as below. Replace Previous Step with your actual previous step.

 

= Table.SelectRows(#"Previous Step", each [Date] >= List.Sort(List.Distinct(#"Previous Step"[Date]), Order.Descending){6})

 

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Fowmy
Super User
Super User

@ajaygajree1 

You need to add a new step as follows:

Click on the Fx button on the last step

Fowmy_0-1638276315356.png

Past this code and modify the #"Changed Type" to your previous step, 

= Table.SelectRows(#"Changed Type", let latest = List.Max(#"Changed Type"[Date]) in each ([Date] <= latest) and ([Date] >= Date.AddDays(latest,- 7) ))

 

Fowmy_1-1638276385817.png



 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

Thank you very much!

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors