Forum Discussion

leniorcortivo's avatar
leniorcortivo
Advocate I
5 years ago
Solved

How to summarize a table for the maximum value

Hello,   I have the following table. Cod 1 Cod 2 Cod 3 2125 1 1 2125 2 1 2125 5 1 2125 8 1 2125 8 2   I want to summarize this table to just show de lines with t...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, leniorcortivo 

    Please check the below for creating a new table.

     

     

    Result Table =
    GROUPBY (
    'Table',
    'Table'[Cod 1],
    'Table'[Cod 2],
    "Cod3", MAXX ( CURRENTGROUP (), 'Table'[Cod 3] )
    )

     

     

    https://www.dropbox.com/s/og3pw910w297dh4/lenior.pbix?dl=0 

     

    Hi, My name is Jihwan Kim.

     

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

     

    Linkedin: linkedin.com/in/jihwankim1975/

    Twitter: twitter.com/Jihwan_JHKIM

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, leniorcortivo 

Please check the below for creating a new table.

 

 

Result Table =
GROUPBY (
'Table',
'Table'[Cod 1],
'Table'[Cod 2],
"Cod3", MAXX ( CURRENTGROUP (), 'Table'[Cod 3] )
)

 

 

https://www.dropbox.com/s/og3pw910w297dh4/lenior.pbix?dl=0 

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM