Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

Hello,

 

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

Here is example data:

SystemVersionDate
A16.9.011/3/2018
A16.11.011/5/2018
A16.10.011/5/2018
B7.8.211/4/2019
B6.5.311/1/2019
B7.0.211/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:

SystemVersionDate
A16.11.011/5/2018
B7.8.211/4/2019

 

But what I'm getting:

SystemVersionDate
A16.9.011/5/2018
B7.8.2

11/4/2019

 

 

I found this post where there is descirbed similar issue:

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

 

Thanks for help :)

Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    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

3 Replies

  • MFelix's avatar
    MFelix
    Super User
    6 years ago

    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