dynamic date filter

[Qianru221]

Hi all,

I have a query which has a date column, which has date from 2000.01.01 to 2099.12.31. I want to filter the date from 2016.01.01 till now.

I therefore write in the M code as

= Table.SelectRows(#"Renamed Columns", each[Date] < Date.From(DateTime.LocalNow()) )

= Table.SelectRows(#"Filtered Rows", each [Date] >= #date(2016, 1, 1))

Then due to analysis requirement, I need the date list to be from 2016.01.01 till 21 days into the future. How should I modified the first M code so that it is possible?

I tried with Date.From(DateTime.LocalNow()+21), but it was obviously not working....

Thanks in advance.

[v-jiascu-msft · Accepted solution]

Hi @Qianru221,

It seems that you are looking for this function Date.AddDays.

You could try to this formula below.

Date.AddDays (Date.From (DateTime.LocalNow ()) , 21)

For reference, you could have a good look at this similar thread.

Best Regards,

Dale