Forum Discussion
Solved
Create a Calculated Column using MAX value from another column of the same table
Hi everyone I have the first 3 columns in this table (tblResources) and I need to create a calculated column (4th column) IdPerson idResource ResourceCost MaxResourceCostbyPerson Jhon r...
AvalBuroAdmin
Add a New Column to your Table:Column = CALCULATE( MAX(Table1[ResourceCost]), ALLEXCEPT(TABLE1,Table1[IdPerson]) )________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
AvalBuroAdmin
Add a New Column to your Table:
Column =
CALCULATE(
MAX(Table1[ResourceCost]),
ALLEXCEPT(TABLE1,Table1[IdPerson])
)
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
Hi,
I was working on something similar but in my case 2000 for the first person, I want to display 2000 only against it and not the other values which are not the greatest. Something like this.
| dPerson | idResource | ResourceCost | MaxResourceCostbyPerson |
| Jhon | rss01 | 1000 | |
| Jhon | rss05 | 1999 | |
| Jhon | rss02 | 2000 | 2000 |
| Peter | rss01 | 5000 | 5000 |
| Peter | rss03 | 2500 |