How to get a concrete value from a table into a measure?

[TesterPowerBI]

Hi all. I'm new in PowerBI, so apologies in advance for the very simple question.

I would like to create a measure that contains the value of Date modified row for Test Run Export XRay.csv file name (see image). In the example below the value I should be getting is: "20/08/2024 18:25:30".

What I need to include in my measure?

Thank you so much in advance!

[Anonymous · Accepted solution]

Hi,ryan_mayu ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.
Hello,@TesterPowerBI .I am glad to help you.
In addition to using the iterative function maxx, you can use the IF judgment or calculate the target value by using the calculate function in conjunction with the max function to achieve your needs.

measure:

M_1 = 
VAR _name=MAX('Table'[Name])
VAR _Extension=MAX('Table'[Extension])
VAR _modified=MAX('Table'[Date modified])
RETURN
CALCULATE(MAX('Table'[Date modified]),FILTER(ALL('Table'),CONTAINSSTRING(_name,"Test Run Support XRay.csv")))

measure:

M_2 = 
VAR _name=MAX('Table'[Name])
VAR _Extension=MAX('Table'[Extension])
VAR _modified=MAX('Table'[Date modified])
RETURN
IF(CONTAINSSTRING(_name,"Test Run Support XRay.csv"),_modified)

Below is my test data:

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TesterPowerBI]

Thanks for the very detailed explanation! It worked.

[ryan_mayu]

@TesterPowerBI 

you can try this

Measure = maxx(FILTER('Table (2)','Table (2)'[name]="Test Run Export XRay.csv"),'Table (2)'[Date modified])