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 - podcast
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
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.