Set Analysis

[Anil_Babu_Samineni]

Hello,

If i select Year i want show Last date of the year using Set Analysis

For ref, PFA

[antoniotiman · Accepted solution]

[mightyqlikers]

PFA.

$@M.

[Anonymous]

Hi Anil,

Try this expression:

Sum({<[Order Date Year] = {'$(=Max([Order Date Year]))'}

,[Order Date] = {'$(=max({<[Order Date Year]={$(=max([Order Date Year]))}>} [Order Date]))'}

>} Sales)

Regards!

[Anil_Babu_Samineni]

Manuel, Sam & Antonio,

Right. As per time Antonio is First one..