Working with version type - multiple decimal points, show latest version

[Anonymous]

Hello,

I'm working with data which contains version column. It has numbers separated by decimals.

Here is example data:

System	Version	Date
A	16.9.0	11/3/2018
A	16.11.0	11/5/2018
A	16.10.0	11/5/2018
B	7.8.2	11/4/2019
B	6.5.3	11/1/2019
B	7.0.2	11/2/2019

there might be different versions per system and we want to take the one that is the most recent one (highest digits).

I have created LATESTDATE measure and i want to show last versions for those last dates for each system.

What I want to get:

System	Version	Date
A	16.11.0	11/5/2018
B	7.8.2	11/4/2019

But what I'm getting:

System	Version	Date
A	16.9.0	11/5/2018
B	7.8.2	11/4/2019

I found this post where there is descirbed similar issue:

• https://community.powerbi.com/t5/Desktop/Sorting-Version-Number-with-multiple-decimal-points-formatt...

But it is good only for sorting, not for printing the exact values we have as version column.

Thanks for help 🙂

[MFelix]

Hi @Anonymous ,

What do you mean by "But it is good only for sorting, not for printing the exact values we have as version column."

Believe that you have an issue with the measures / calculation you are using, can you share what are the setup you have on the table

But what I'm getting:

System	Version	Date
A	16.9.0	11/5/2018
B	7.8.2	11/4/2019

Regards,

MFelix

[Anonymous]

@MFelix , sharing pbix file.

• https://dnv-my.sharepoint.com/:u:/g/personal/rafal_glebocki_dnvgl_com/EXw-RrOfaJtIm19ZFL29AnkBQLlQUd...

I thought about breaking it by decimals, sorting out and removing duplicates  - in second table. And then just join it.

[MFelix · Accepted solution]

Hi @Anonymous ,

Try the following measure for Last version:

Last version =
CALCULATE (
    MAX ( 'Table'[Version] );
    FILTER (
        ALL ( 'Table'[Date]; 'Table'[System] );
        'Table'[Date] = MAX ( 'Table'[Date] )
            && 'Table'[System] = MAX ( 'Table'[System] )
    )
)

Should work as expected, see file attach.

Regards,

MFelix