set analysis in calculated dimension

[souadouert]

I wat to create calculated dimension  ,with set analysis expression

display the value of column x for the max date

[tresB]

May be like:

Only(Total {<Date={'$(=Date(max(Date)))'}>} Column)

[tresB · Accepted solution]

Well, if I go with sample screen shot, try like:

=Date(Max(total Date#(DATE,'YYYYMM')), 'YYYYMM')

[sunny_talwar]

C6 300 is on 201705, why would you be seeing that?

[souadouert]

I want show always the lastest value

[sunny_talwar]

But C6's latest value is on 201705 and not 201706? how are you seeing this next to 201706?

[souadouert]

y are raight sunny

[sunny_talwar]

So, is the issue resolved now? I am confused

[souadouert]

Yes sunny thank youuuu