Power Bi Desktop table with duplicates

Hello,

as a fairly new user of Power Bi, I have a question that will hopefully lead to a solution.

There are 2 columns in my table...

"Offer number" column (example value of one row: 986000130 )

In the best case, this offer/ number exists once and that's it...

but..

there is also a column "version number"

There is always a zero here if there is no other version of the offer number.

However, if the offer with the number 9860000005 was saved as version 1, 2 or 3, the offer 9860000005 will exist in several rows of my table.

Now how can I get Power Bi to always keep the highest number of the version and delete the lines of the other versions including the 0 version in tghe table....????

Thanks a lot for your support, if possible 🙂