Forum Discussion

user35131's avatar
user35131
Helper III
4 years ago

Get Max date by group but from variable table

Normally i would this code     Max Date = CALCULATE ( LASTDATE ( Table[Date] ), ALLEXCEPT ( Table, Table[ID], Table[Col2] ) )     Var= threein1   VAR MA...
Need Help
v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

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.