• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Maximum of Column Value

SHefer

New Member
I am battling to determine a measure (or other means) to determine the maximum value in a powerpivot column - and would like some help!

With reference to the attached screen shot, I have a column (Nr of Events) that simply counts each time a row has an event - in this case an event is designated by 1 in the Count BD column.

Sooo, how do I extract the maximum value for this column for a changing data set?

Thanks
 

Attachments

  • Capture.JPG
    Capture.JPG
    51.8 KB · Views: 25
I'm a bit confused. Are you trying to extract Max of BD or other column from Analysis cube? Or are you trying to extract Max Nr of Events from Pivot?
 
I'm trying to extract the max from column "Nr of Events" - based on the screen shot, the value I'm looking for is 17.
 
You can just do it as plain Excel formula, while possible to do it as measure, not efficient as it returns single value for series of data.

Try something like...
=MAX(OFFSET($B$2,0,0,COUNT(B:B)-1))

Replace $B$2 with cell reference to first value for Nr of Events, and B:B to the column where Nr of Events is kept. If there is no total at bottom, you may not need -1.
 
Back
Top