Return value using MAX date

[M_SBS_6]

Hi, 

I'm trying to create a new column based on the following logic, but not quite sure what I am doing wrong as its populating the same value for every row. 

VAR _Maxdate =

Calculate (

MAX (apps.date_in),

FILTER (apps, not (apps.name) in {"test",""}))

RETURN

LOOKUPVALUE(

apps.name,

apps.date_in, _maxdate, "")

Any ideas please? 

[amitchandak]

@M_SBS_6 , a new column

if( isblank([App.Name]) || [App.Name] ="test" , "no", max([Date]) &"" )

[M_SBS_6]

Thanks for your suggestion but doesn't quote work. What I hope to see in this example is either "No" or "Test2" as that's the MAX value where its not "" or "test"

App.name  apps.date_in 

Test.   24/05/2023 14:20:09

Test1  24/05/2023  11:14:12

Test2 24/05/2023.   12:32:46