Forum Discussion

kabra_ashish's avatar
kabra_ashish
Icon for Helper III rankHelper III
6 years ago
Solved

Finding MAX in each category

Need some quick help.   I have a table in my data model as below:   Record       Name           Dates                Transactions (#) 1                   A              Jan-01-2020              ...
  • AllisonKennedy's avatar
    AllisonKennedy
    6 years ago
    You could try this as a calc column:

    IsMax - IF( 'Table1'[Transaction] a MAXX(FILTER(ALL('Table1'), 'Table1'[Name] ? EARLIER('Table1'[Name])), 'Table1'[Transaction]), "Yes", "No")
kabra_ashish's avatar
kabra_ashish
Icon for Helper III rankHelper III
6 years ago

Thanks Anonymous 

 

However it throws and error in the variable created. Its says "Too few arguments were passed to the MAXX function. The minimum argument count for the function is 2."

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI kabra_ashish ,

 

I missed adding Table[Transactions]

 

 

Maximum Transaction =
VAR _max =
    MAXX (
        FILTER (
            'Table',
            'Table'[Name]
                = EARLIER ( 'Table'[Name] )
        ),
        Table[Transaction]
    )
RETURN
    IF (
        'Table'[Transaction] = _max,
        "Max Value",
        BLANK ()
    )

 

Also, the solution from AllisonKennedy  will work.  

 

 

Regards,

Harsh Nathani