Get Max date by group but from variable table

[user35131]

Normally i would this code

Max Date =
CALCULATE (
    LASTDATE ( Table[Date] ),
    ALLEXCEPT (
        Table,
        Table[ID],
        Table[Col2]
    )
)

Var= threein1

VAR MAX_ =

SUMMARIZE(Table,[id],[Col2],"MAX DATE",LASTDATE(threein1))

Return MAX_

However I am working off of a variable so when  i try to do this in lastdate function I can't reference the column from the created variable.

[v-yalanwu-msft]

Hi, @user35131 ;

First SUMMARIZE() is to return a table, and here you are returning a measure:
Try it:

measure =
MAXX (
    SUMMARIZE ( Table, [id], [Col2], "MAX DATE", LASTDATE ( threein1 ) ),
    [MAX DATE]
)

 If not, can you share a simple example and the desired output? The daX alone cannot fully determine the cause. and the threein1 is measure ?

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[user35131]

A measure i created outside did not get accepted when trying to input. 

[Fowmy]

@user35131 

If you assign a value to a variable, it becomes a constant and any changes in the context will not affect it. In this case, you need to substitute the actual calculation for the variable.  

[user35131]

isn't that what i'm trying to do. The calculation does not give me a result. 

[Fowmy]

@user35131 

Var= threein1

VAR MAX_ =

SUMMARIZE(Table,[id],[Col2],"MAX DATE", "------No Variable/Enter Actual Measure------" )

Return MAX_