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 🙂
There are many ways to do this but here's one option:
MaxResourceCostbyPerson =
CALCULATE (
MAX ( TableName[ResourceCost] ),
ALLEXCEPT ( TableName, TableName[IdPerson] )
)
Thanks so much. It worked.