Max week of current month/year selection

[felipe_oliveira]

Hi masters

I have the filter below:

How can I find the amount of the last week of the max year and month selected?

In the example above, the latest selected month and year are October and 2017, thus the week should be 44, which is the last week of October 2017.

I have set the following variables:

vFieldYear = max([Year])

vFieldMonth = max([Month])

vFieldWeek = max(week($(=($(vFieldMonth)))))  <----- this one seems to be not working as expected

I have tried the following with no success:

=sum({<Year={$(=($(vFieldYear)))},Month={$(=($(vFieldMonth)))}, Week={$(=($(vFieldWeek)))}>}amt_to_finance)

=sum({<Week={$(=($(vFieldWeek)))}>}amt_to_finance)

Please help me

Thanks

Felipe Oliveira

[jpenuliar]

Hi Felipe,

Do you have a a field containing dates(Daily) or a field derived by WeekName(Date)

WeekName(Date) as field_Week

then use Max(field_Week)

[YoussefBelloum]

Hi,

do you have your amt_to_finance measure per DATE or per week ?

[felipe_oliveira]

I have both, date and week

[antoniotiman]

Why not

Week(Max(DateField))

[YoussefBelloum · Accepted solution]

=sum({<week={$(=max(Week(date)))}>}amt_to_finance )

[felipe_oliveira]

Thanks Youssef! You the man!