Filter Date for Last 7 Days of Data

[Anonymous]

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!

[mahoneypat]

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

[Fowmy · Accepted solution]

@Anonymous 

You need to add a new step as follows:

Click on the Fx button on the last step

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

[Anonymous]

Thank you very much!