Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)