Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
= Table.SelectRows(#"Changed Type1", each [Package] = null or [Date] > Date.AddDays(DateTime.Date(DateTime.FixedLocalNow()),-30))
Hi @murali5431
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
= Table.SelectRows(#"Changed Type1", each [Package] = null or [Date] > Date.AddDays(DateTime.Date(DateTime.FixedLocalNow()),-30))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.