Create new Table with latest records

[slav84]

Hello, 
I have a table from which I need to create new table that will agreggate the data based on Seller and only for the latests date for which i have data for.
First i created measure that will store the last date of my data.
MaxDate = Max('SellerPrices'[Date]')
Which indeed returns the latest date i have in my dataset

Now, when creating the table, I am using ADDCOLUMNS(SUMMERIZE....
And then creating column Amazon which will be the sum of all prices for amazon for the latest data for which i have the data. 

TestTable =

ADDCOLUMNS(

SUMMARIZE('SellerPrices','SellerPrices'[Date],'SellerPrices'[Brand],'SellerPrices'[Product]),

"Amazon",CALCULATE(SUM('SellerPrices'[Price]),'SellerPrices'[Seller] = "Amazon", 'SellerPrices'[Date] = [MaxDate]))

But when i do this I am getting an error:
"A function 'PlACEHOLDER' has been used in s True/False expression that is used as table expression filter. This is not allowed. "

Any idea what am i doing wrong here?

[slav84]

Thank you. 
That worked. 
But why did this work and not with measure?

[mangaus1111]

Because indeed a variable is a constant, is a number and it is accepted in the 2nd argument of the Calculate function.

[mangaus1111 · Accepted solution]

Hi @slav84 ,

try to write [MaxDate] not like a measure, but like variable.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.