Removal of rows having date 30 days before latest date using Power query

[murali5431]

Hi,

I have  package information as below with their dates

Package	Date
ABCD1234	1-Sep-21
null	1-Sep-21
ABCD1234	1-Sep-21
ABCD1234	9-Oct-21
ABCD1234	1-Oct-21
null	10-Oct-21
ABCD1234	9-Oct-21
null	10-Oct-21
null	10-Oct-21
ABCD1234	10-Oct-21
MNOP5678	15-Sep-21
MNOP5678	20-Oct-21
null	15-Sep-21
MNOP5678	1-Oct-21
MNOP5678	10-Oct-21
MNOP5678	10-Oct-21
null	10-Oct-21
MNOP5678	1-Oct-21
null	10-Oct-21
null	10-Oct-21
MNOP5678	15-Sep-21
MNOP5678	10-Oct-21

I need assistance with how I can remove rows that are older than 30 days from current date (Current date - date in table > 30 should be deleted) while retaining null value rows, in Power query.

Thanks in advance!

Regards,

Muralidhar

[mwegener]

Hi @murali5431 

this should work

= Table.SelectRows(#"Changed Type1", each [Date] > Date.AddDays(DateTime.Date(DateTime.FixedLocalNow()),-30))

[murali5431]

Thank you @mwegener 

Can you let me know how to retain the rows having "null" in column A. I believe that was not considered in the above query

[mwegener · Accepted solution]

= Table.SelectRows(#"Changed Type1", each [Package] = null or [Date] > Date.AddDays(DateTime.Date(DateTime.FixedLocalNow()),-30))