Home Forums Power Pivot SMALL()-Function in PowerPivot

This topic contains 1 reply, has 1 voice, and was last updated by  MagicT 6 years, 9 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #8184

    MagicT
    Participant
    • Started: 1
    • Replies: 1
    • Total: 2

    Hey there,

    so i am trying to create a measure in powerpivot which should give me the ten lowest prices per article – and then put that measure in a pivottable to see the customers name behind that price.

    But unluckily i realized there is no such cool thing in powerpivot then SMALL() in common excel does. Am i only to stupid to realize such thing does exist in powerpivot or do i need to solve it with some tricks in a measure?

    Any help appreciated.

     

    Cheers,

    TH

    #8186

    MagicT
    Participant
    • Started: 1
    • Replies: 1
    • Total: 2

    Nobody? I really need help to finde the 2nd, 3rd min value …

Viewing 2 posts - 1 through 2 (of 2 total)

The forum ‘Power Pivot’ is closed to new topics and replies.