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
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