Max Value

[#1]

Hi Community,

How to get Max value for 2 parametres.

Ex:

I want Count of X value with two parametres

EX:   Count(Max(CurrentMonth, CurrentYear)X)

[#2]

Hi,

Try like below,

Count({<CurrentMonth={"$(=Max(CurrentMonth)"}, CurrentYear={"$(=Max(CurrentYear)"}>}X)

[sunny_talwar]

Not really sure I understand your requirement, but may be this:

FirstSortedValue(X, -CurrentYear&CurrentMonth)

[MK_QSL · Accepted solution]

=COUNT({<Year = {'$(=Max(Year))'},Month = {"$(=Month(MakeDate(Year(Today()),Max({<Year = {'$(=Max(Year))'}>}Month))))"}>}X)