Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
@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.
First Create a variable in like this:
then use the following expression:
Max({<[Order Date] = {"$(=Date($(vMaxDate)))"}>}Sales)
@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.