Forum Discussion
Filter out old data basis timestamp column
Hello A, thank you for taking out time to reply. Since i am very new to Power BI, my question might feel silly.
i am trying to filter old data in the query editor itself so that i can bring only latest data for my future calculations. how do i write your formula inside query editor?
Why do you want to do in Power Query.
Hello Arjunarao - Thank you for your reply.
I want to do it in query editor, since once i remove the old data rows, then the modified data set will be integrated alongwith other tables.
Current problem - I receive a new file with data only for a particular employee whose data has been changed but i cant delete the old data from the file itself. hence i want to remove the old data using query editor but at the same time preserve the data in input files.
can we put a counter which will give 1,2,3 basis the latest timestamp for each employee and reset itself to 1 for each new employee. that way, i can try to group records basis the max value for each employee