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")
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi kabra_ashish ,

 

Maximum Transaction =

 

var max = MAXX(FILTER('Table', 'Table'[Name] = EARLIER('Table'[Name]))

 

RETURN

IF( 'Table'[Transaction] =  max ,  "Max Value", BLANK())

 

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

  • 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