I have package information as below with their dates
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!
Go to Solution.
= Table.SelectRows(#"Changed Type1", each [Package] = null or [Date] > Date.AddDays(DateTime.Date(DateTime.FixedLocalNow()),-30))
Marcus Wegener work at KUMAVISION AG , one of the world's largest implementation partners for Microsoft Dynamics. #"Get the most out of data, with Power BI." twitter - LinkedIn - YouTube - website
View solution in original post
this should work
= Table.SelectRows(#"Changed Type1", each [Date] > Date.AddDays(DateTime.Date(DateTime.FixedLocalNow()),-30))
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
Click here to read more about the November 2022 updates!
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.