Help to filter data

[Anonymous]

Dear friends,

I need your support. I'm trying to do a flow that links GoogleForms with Power BI. I can't edit my database, so i need a filter to help me "delete" wrong forms sent by mistake. Example: In  the picture the 5th column is the number of the apartment and in the first column is the number of the copy (version). I need to make a filter that selects the last version for all apartments.

Can you give me any insights to solve this proble?

[GilbertQ]

Hi @Anonymous 

What you could do is to filter it by Date, and select the MAX Date?

Here are details on how to do this below:

Grouping or summarizing rows | Microsoft Docs

And for the summarization select MAX which will always select the biggest Date.