Forum Discussion

swebb's avatar
swebb
Helper II
3 years ago

Need help removing rows with certain date

All,

 

I have a "createdon" column from a table imported via a Data Flows from CRM. I need all rows dated prior to 1/1/2022 removed. I believe doing this in Power Query would be the easiest, as there are several thousand rows to remove. I'm struggling trying to get the correct syntax to do this. From what I have found and read, it seems like the answer is to create an additional table. I would really like to avoid that if possible, as I already have a report built, but have been tasked with adding new requirements. Thoughts on best approach?

Need Help
Tips and Tricks

1 Reply

  • m_alireza's avatar
    m_alireza
    Solution Specialist
    3 years ago

    Hi swebb ,

    You can open Power Query editor, click on down arrow next to the createdon column > Date Filters > After 

    Then in the pop up box, you can select to keep rows where your createdon column is after or equal to  1/1/2022