Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm trying to create a customized subtotal calculation in a table. I want to present a table like this but have not found the right formula. The challenge is to have a subtotal with a calculation A+B and have the hierarchy (sheet-Section-Line_item) working as well
Value | ||
A | Operating income | 1700 |
Net interest income | 1000 | |
Financial income | 600 | |
Net fee and commission income | 100 | |
B | Operating expense | -800 |
Other expense | -300 | |
Salary | -500 | |
Net Earnings before tax (A+B) | 1700-800=900 | |
Net Impairment | 200 | |
Impairment | 200 | |
Net Earnings | sum(value) |
The data look something like this
Value | sheet | section | line_item | in_earnings_before_tax |
-410 | Income statement | Operating income | Net interest income | 1 |
-128 | Income statement | Operating income | Net interest income | 1 |
-500 | Income statement | Operating income | Net interest income | 1 |
-178 | Income statement | Operating income | Net interest income | 1 |
-431 | Income statement | Operating income | Net interest income | 1 |
-251 | Income statement | Operating income | Net interest income | 1 |
-43 | Income statement | Operating income | Net interest income | 1 |
-24 | Income statement | Operating income | Net interest income | 1 |
-15 | Income statement | Operating income | Net interest income | 1 |
-58 | Income statement | Operating income | Net interest income | 1 |
-112 | Income statement | Operating income | Net interest income | 1 |
-319 | Income statement | Operating income | Net interest income | 1 |
-725 | Income statement | Operating income | Net interest income | 1 |
-121 | Income Statement | Net Impairment | Impairment | 0 |
Any help/hints would be greatly appreciated
Hi @atlihaukur,
For your scenario, if you want to show the output as table, I'm afraid that we may not achieve that.
What about creating matrix it will show subtotal value for each level.
Best Regards,
Cherry
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |