How to get Max Financial quarter dynamically

[#1]

Hi All,

I am using the the expression which is not working

=MaxString({$<[Year]=MaxString([Year])>}[Quarter]) &Mid(MaxString([Year]),3,2)

could you please let me known how to slove my problem?

Thanks

[adamwilson · Accepted solution]

for the first part try:

= MaxString({$<[Year]= {$(=MaxString([Year]))}>}[Quarter])

I cant see anything wrong with the syntax for the second part:

Mid(MaxString([Year]),3,2)