Forum Discussion
Date Manipulation
I'm trying to create a query that references a previous query but removes the last 3 days worth of contents. Although I could just run another SQL query to do this, I thought it may be more efficien...
That would work too, or you could just add "not" to what I sent before
=Table.SelectRows(#"Changed Type", each not Date.IsInPreviousNDays([date], 3))
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
mahoneypat
Microsoft Employee
Microsoft EmployeeThat would work too, or you could just add "not" to what I sent before
=Table.SelectRows(#"Changed Type", each not Date.IsInPreviousNDays([date], 3))
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Thanks mahoneypat 🙂