Date filter except last 6 days

[vinicius_ramos]

I want to automatically create a date filter that always disregards the last 6 days.
For example, I have a database for the last 30 days and I want to get the data disregarding the last 6 days.
For example, today is the 30th, I have data from the 1st, if I disregard the last 6 days I would have to have data from the 1st to the 24th.
Can anyone help me, to do this filter in power query?

thanks!

[watkinnc]

= Table.SelectRows(PriorStepOrTableName, each [Date] < Date.AddDays(Date.From(DateTime.LocalNow()), -6))

--Nate

[vinicius_ramos]

Hi @watkinnc 

Didn't work. The expression error in "PriorStepOrTableName"

Do you have any other suggestions?

Tks

[RobinHaerkens]

Hi @vinicius_ramos

With "PriorStepOrTableName" @watkinnc is referring to the name of the prior step/table in your coding. Hope this helps!

[vinicius_ramos]

Hello, @RobinHaerkens 

Sorry I dont understand, I need to create a new custom colunm?

tks.