Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello good day,
I am trying to perform a check balance where I have transactions in rows with account codes that must be sumed with respect to their parent account code, that is, I have a table with all my account codes and their parent account codes, I must iterate each row and add in the row of the parent account all the account codes that correspond to this , left example of my table with transactions:
And this is the table I'd be trying to build:
At the moment I've tried several formulas like Calculate, Sumx, Earlier.
I appreciate your help.
Solved! Go to Solution.
It looks like you could implement the pattern found at https://www.daxpatterns.com/parent-child-hierarchies/ .
Proud to be a Super User!
It looks like you could implement the pattern found at https://www.daxpatterns.com/parent-child-hierarchies/ .
Proud to be a Super User!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 43 | |
| 42 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 190 | |
| 122 | |
| 96 | |
| 66 | |
| 47 |