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.
Is it possible to add accumulating sub totals into a matrix table in Power BI. So for example Income, cost of sales and then a subtotal called gross profit, then overheads and another subtotal called net profit. The net profit would be a calculation of gross profit + overheads and not just total the overheads
Solved! Go to Solution.
Hi @guyclewlowi2,
>>So for example Income, cost of sales and then a subtotal called gross profit, then overheads and another subtotal called net profit. The net profit would be a calculation of gross profit + overheads and not just total the overheads
Power bi not support these feature, you should write measures to calculate for these calculations and drag them to values field.
Regards,
Xiaoxin Sheng
Hi,
This can be done in Excel using CUBE functions.
These each would be written as separate measures(i.e. [Income], [Cost of Sales], and [Gross Profit]), then in your matrix you would use the new "show measures on rows" formatting feature to get the layout you're describing.
Proud to be a Super User!
Hi @guyclewlowi2,
For your scenario, I think you can keep the original table structure to build a sample file with some fake data , then share it here.
Regards,
Xiaoxin Sheng
Please see below a link to the power BI example table and the example data
Hi @guyclewlowi2,
>>So for example Income, cost of sales and then a subtotal called gross profit, then overheads and another subtotal called net profit. The net profit would be a calculation of gross profit + overheads and not just total the overheads
Power bi not support these feature, you should write measures to calculate for these calculations and drag them to values field.
Regards,
Xiaoxin Sheng
Can you provide some sample data so that we can have better understanding towards result formulation?
Regards,
Hemant
Hi Hemant,
Thanks for replying to the post, because its company financial data I cant share but it is typical nominal ledger transactions (in this case from SAGE 50)
You can obviously mask the data & provide us for our understanding towards its structure & the result you want to replicate out of it.
Regards
Or use https://www.mockaroo.com/ to make some fake sample data that has the same structure.
Proud to be a Super User!
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |