Get version number of customers latest case

[Topjacket]

Hi All

I have a measure which has been working fine up until I refreshed the data. It broke the visual it was in and I can tie it back to just one customer, however, looking through the data I can't see any reason for it to brake. The version number is prefixed with "Version " and this customer has always been in the data.

I am using the following measure.

Latest Version = SUBSTITUTE(LOOKUPVALUE('Customer Data'[Version],'Customer Data'[SysDate], max('Customer Data'[SysDate])),"Version " ,"")

I then have a mtrix report broken down by customer, this measure has then been returning each customer's latest version without issue.

Is there a better way to set out this measure or would it be better as a column? 

Any advise would be great.

Thanks

[Topjacket]

Hi

Here is an example of the data the measure is using. I need to look for the latest case per cusotmer and return the version. 

Cust1 = 2

Cust2 = 4

Cust3 = 5

ID	Customer Name	SysDate	Version
1	Cust1	12/02/2023	Version 1
2	Cust2	01/01/2023	Version 4
3	Cust3	02/02/2023	Verison 1
4	Cust1	26/02/2023	Version 2
5	Cust2	22/12/2022	Version 2
6	Cust3	01/03/2023	Verison 5

[andhiii079845]

Thank you. You mentioned the measure works fine in a matrix. But in which case did the measure not working correctly. Can you explain your problem better? 

[Topjacket]

Its only in a single matrix. It was working fine until I refeshed the data so was really just seeing if there was a better way to acheive the same result.

I don't now how better I can explain what I am trying to acheive as its a pretty basic concept but now you have replied I'm unlikely to get replies from anyone else,  so thanks very much for that.

[andhiii079845]

Without a some screenshot of the visual, involved tables and columns. .It is for me not possible to help.