Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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