Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filter for max value based upon another column

Hi,   I would like to filter for the max value in one column based upon another column which is a project name over a range of time.   Basically I want to find the max total employees for each pr...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous ,

     

    One sample for your reference. Here we can create a calculated column as below to work on it.

     

    max total = CALCULATE(MAX(Table1[Total Employees]),FILTER(Table1,Table1[Project name]=EARLIER(Table1[Project name])))

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

Hi Anonymous ,

 

One sample for your reference. Here we can create a calculated column as below to work on it.

 

max total = CALCULATE(MAX(Table1[Total Employees]),FILTER(Table1,Table1[Project name]=EARLIER(Table1[Project name])))

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    thank you very much