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 🙂
Fowmy
Super User
Super UserAvalBuroAdmin
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.