Retain only the current version

[JB17]

hello everyone, can anyone of you help me on DAX measure, I only need to retain the most current version per system ID on the above visual to avoid duplication. Appreciate your help. thanks!

[amitchandak]

@JB17 , refer if these DAX solutions can help

Latest
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...

or refer power query solution

https://www.youtube.com/watch?v=hidJ5T_DYQ0