Transforming Data - Sales orders and archived versions (Business Central Data) - Or DAX ?

[bco_lde]

Hi there

I want to evaluate how many versions per Sales Quotes our company produce in order to achieve a final result.

Business Central adds each "archived" version as a single line to the archives-table, with a row for quote number (which does not change) and a verson number, counting up. 

Now I think for my intent I would only need the line per Doc-No. with the highest Version-No. 
Is it possible to transform the table to keep only that line per Doc-No. or would I have to keep those and build something else entirely ? 
My approach then would be to just add up all version counts. count distinct number of doc-NO and divide and be done with it. 
but this doesnt work if I have all lower version numbers inflating the data: 

looing forward for any help / suggestion

thanks in advance

[amitchandak]

@bco_lde , BAsed on what I got

Keep Latest date - Power query (This will remove data)
https://www.youtube.com/watch?v=hidJ5T_DYQ0
https://exceleratorbi.com.au/remove-duplicates-keep-last-record-power-query/

Latest based on DAX measure( no data removal)
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee8...