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 š
Thanks, it worked.
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
