topic Re: Create a Calculated Column using MAX value from another column of the same table in DAX Commands and Tips

Create a Calculated Column using MAX value from another column of the same table

AvalBuroAdmin — Thu, 03 Sep 2020 19:50:34 GMT

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	rss01	1000	2000
Jhon	rss05	1999	2000
Jhon	rss02	2000	2000
Peter	rss01	5000	5000
Peter	rss03	2500	5000

Wich Dax expression should i use to create the column MaxResourceCostbyPerson, every row should have the MAX value of ResourceCost for that IdPerson.

Hopefully someone can help me.

Rewards.

Re: Create a Calculated Column using MAX value from another column of the same table

AlexisOlson — Thu, 03 Sep 2020 19:58:31 GMT

There are many ways to do this but here's one option:

MaxResourceCostbyPerson = CALCULATE ( MAX ( TableName[ResourceCost] ), ALLEXCEPT ( TableName, TableName[IdPerson] ) )

Re: Create a Calculated Column using MAX value from another column of the same table

Fowmy — Thu, 03 Sep 2020 20:01:55 GMT

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 🙂

YouTube LinkedIn

Re: Create a Calculated Column using MAX value from another column of the same table

AvalBuroAdmin — Thu, 03 Sep 2020 20:18:51 GMT

Thanks so much. It worked.

Re: Create a Calculated Column using MAX value from another column of the same table

AvalBuroAdmin — Thu, 03 Sep 2020 20:19:27 GMT

Thanks, it worked.

Re: Create a Calculated Column using MAX value from another column of the same table

sunnyzags — Wed, 26 Jul 2023 11:58:53 GMT

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