Expression if statement

[Anonymous]

Hello,

Can anybody help or advize me with the next expression?

I need the result from column X of WeekEinde 28-6-2015 to show in the dashboard as month Juny

I do not want to change the calendar, because not all the data is a count like that, mostly it is a sum of the data from the weeks belong Juny..

if(Max(WeekEinde) < JaarMaand, sum(X))

Thanks already!

[lironbaram]

hi

something isn't clear enough for me in your expression

you compare to fields that contains different set of data

you can try

=FirstSortedValue(aggr(sum(X),WeekEinde),aggr(-WeekEinde,WeekEinde))

[Anonymous]

Hello Liron,

Your answer works fine!

Thanx very much for the hint.

Greets, Nelly

[lironbaram]

hi good to hear

so please mark the answer as correct so future users could benefit from it also