Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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 |
Thanks, it worked.
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.
User | Count |
---|---|
52 | |
51 | |
20 | |
17 | |
16 |
User | Count |
---|---|
113 | |
46 | |
44 | |
28 | |
22 |