Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
39 | |
24 | |
21 | |
21 | |
13 |