Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
max(if(not IsNull(Sales),Year))
or
max({<Sales={'*'}>}Year)
Something like this should do it: max({<SalesValue={'*'}>} Year). Replace SalesVales and Year with the names of your dimensions.