Max function on date in dimension in straight table

[#1]

Hi

I have a date field in dimension in straight table and I wan to use max date but max function no working in if condition on date.

It's like I want to show products for max date in straight table.

What to do?

Thanks

Saurabh

[ashfaq_haseeb]

HI,

Look at firstsortedvalue() Function

Regards

ASHFAQ

[Anonymous]

use this   =FirstSortedValue(Products, -[DateDim])

[jagan · Accepted solution]

Hi,

Try like this

Dimension: Product

Expression: Date(Max(Date))

OR

Displays the list of products which exists on max date.

Dimension: Product

Expression: Only({<Date={'$(=Max(Date))'}>} Date)

Hope this helps you.  If this is not you are expecting come up with some sample data and expected output.

Regards,

Jagan.