Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Power pivot second biggest value based on filter

Hi,    I have a table and there i have certain products. Some of the products are interchangeable with eachother depending on the packsize. i made a key to connect the products and now it want to s...
Need Help
  • Kaly's avatar
    Kaly
    4 years ago

    Hi Anonymous ,

    According to your description, here's my solution. Create a calculated column.

    Column =
MAXX (
    FILTER (
        'Table1',
        'Table1'[Key] = EARLIER ( 'Table1'[Key] )
            && 'Table1'[Packsize] <> 'Table1'[biggest value]
    ),
    'Table1'[Packsize]
)

    Get the correct result.

    Best Regards,

    Kaly

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Kaly's avatar
Kaly
Resolver II
4 years ago

Hi Anonymous ,

According to your description, here's my solution. Create a calculated column.

Column =
MAXX (
    FILTER (
        'Table1',
        'Table1'[Key] = EARLIER ( 'Table1'[Key] )
            && 'Table1'[Packsize] <> 'Table1'[biggest value]
    ),
    'Table1'[Packsize]
)

Get the correct result.

Best Regards,

Kaly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.