I'm working with data which contains version column. It has numbers separated by decimals.
Here is example data:
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:
But what I'm getting:
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 🙂
Go to Solution.
Hi @roofi00 ,
Try the following measure for Last version:
Last version =
MAX ( 'Table'[Version] );
ALL ( 'Table'[Date]; 'Table'[System] );
'Table'[Date] = MAX ( 'Table'[Date] )
&& 'Table'[System] = MAX ( 'Table'[System] )
Should work as expected, see file attach.
Proud to be a Datanaut!
View solution in original post
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
@MFelix , sharing pbix file.
I thought about breaking it by decimals, sorting out and removing duplicates - in second table. And then just join it.
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!