Expression with date filter

[Dutch_dude]

Hi,

I am trying to create a measure that computes the max of a field for the rows where date equals the maximum date. So the  maximum value of a field for the latest period in my data. I guess it should be something like  =max({<date={max(date)}>} field). I have tried many things, but can't get the measure to work properly. Can anyone help me?

Many thanks in advance!!

[Uzumaki_N]

First Create a variable in like this: 

then use the following expression:

Max({<[Order Date] = {"$(=Date($(vMaxDate)))"}>}Sales)

[sidhiq91 · Accepted solution]

@Dutch_dude  You can use the below expression as your expression to get the desired output.

Max({<OrderDate={"$(=Max(OrderDate))"}>}LineSalesAmount)

If this resolves your issue, please like and accept it as a solution.