Get Latest Year for Sales

[#1]

Hi everyone,

I have a date dimension which has years 2000 up to 2025.

I need to get the latest year that has sales (in this case 2013), and need to display this value in a simple text object.

Can anybody provide some pointers to write this expression?

Thanks,

J

[sivarajs · Accepted solution]

max(if(not IsNull(Sales),Year))

or

max({<Sales={'*'}>}Year)

[Gysbert_Wassenaar]

Something like this should do it: max({<SalesValue={'*'}>} Year). Replace SalesVales and Year with the names of your dimensions.