Max year max month

[rajni_batra]

hello m using this expression getting result for max year but max month only on selection..

i have to use it on dashboard so cant use selection there..

what should i use there tried only() also

sum({<[CAL.Fiscal Year]={$(=MaxFiscalYearGL)},[CAL.Fiscal Month]={"=$(=max([CAL.Fiscal Month Num]))"}, BSubHead = {'CURRENT ASSETS'}>}[Closing Balance])

[jagan]

Hi,

Try this expression

=sum({<[CAL.Fiscal Year]={$(=Year(Max(YourDateDimensionName))},[CAL.Fiscal Month]={"=$(=Month(max(YourDateDimensionName)))"}, BSubHead = {'CURRENT ASSETS'}>}[Closing Balance])

Hope this helps you.

Regards,

Jagan.

[adhudson]

Hi,

     Give a try with the below expression.

     You may need to # or single quotes while using variables and expressions in set analysis.

     sum({<[CAL.Fiscal Year]={'$(#=MaxFiscalYearGL)'},[CAL.Fiscal Month]={'=$(#=max([CAL.Fiscal Month Num]))'}, BSubHead = {'CURRENT ASSETS'}>}[Closing Balance])

Regards

Andrew Hudson

[rajni_batra]

hi andrew...

giving the same result

[rajni_batra]

Helo jagan,

actualy the problem is i have only calender date but here i need to work on fiscal terms derived fiscal month n year.

[jagan]

Hi,

Can you post some sample data or file you are working.

Regards,

Jagan.

[CELAMBARASAN]

Hi,

     Try with this

     sum({<[CAL.Fiscal Year]={$(=Max({1} [CAL.Fiscal Year]))},[CAL.Fiscal Month]={"=$(=max([CAL.Fiscal Month Num]))"}, BSubHead = {'CURRENT ASSETS'}>}[Closing Balance])

Celambarasan

[rajni_batra]

same output as before

[CELAMBARASAN]

Hi,

     you mentioned Max month only on selection that means?If not selected what type of output you need to get?

Celambarasan

[rajni_batra]

current year current month

previous year current month

on dashboard without any selection