PowerPivot：如何确定计算列中每组的最大值 [英] PowerPivot: How to identify Max Value per Group in a Calculated Column

问题描述

我正在为PowerPoint 2013在Power Pivot中构建数据模型，并且需要能够识别特定组的列中的最大值。不幸的是，我以为会工作，我以前搜索过的东西给了我一个错误或不适用（有一个类似的问题，处理计算措施，而不是列，并且在Power Pivot数据视图中不可复制到最好的我的知识）

我已经包括了我下面要实现的内容，在这种情况下，我试图计算最大吸收列数。

  Group |吸收％最高摄取量
 
 A 40 45 
 A 22 45 
 A 45 45 
 B 12 33 
 B 18 33 
 B 33 33 
 C 3 16 
 C 16 16 
 C 9 16 
  

---

非常感谢

解决方案

使用

  = CALCULATE（MAX（[UPTAKE]），FILTER（Table1，[GROUP] = EARLIER（[GROUP]）））
  / pre> 
I am building a data model within Power Pivot for Excel 2013 and need to be able to identify the max value within a column for a particular group. Unfortunately what I thought would work and what I have searched for previously gave me an error or wasn't applicable (there was a similar question that dealt with calculated measures rather than columns and wasn't replicable in Power Pivot data view to the best of my knowledge)

I have included an indication of what I am trying to achieve below, in this case I am trying to calculate the Max % uptake column.
Group | % uptake | Max % uptake            

A            40          45      
A            22          45                        
A            45          45                       
B            12          33                       
B            18          33                                   
B            33          33                       
C            3           16                       
C            16          16                                  
C            9           16 




Many thanks
解决方案
Use
=CALCULATE(MAX([UPTAKE]),FILTER(Table1,[GROUP]=EARLIER([GROUP])))


                        
这篇关于PowerPivot：如何确定计算列中每组的最大值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！