Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello,
I want to display output table B from data table A.
Too difficult for me.
Please Help me !
data table A
Date | DIV | value |
2020/04 | Net Sales | 600,000 |
2020/04 | Cost of Sales | 300,000 |
2020/04 | Gross Profit | 300,000 |
2020/04 | SGA expenses | 120,000 |
2020/04 | Operating income | 180,000 |
2020/05 | Net Sales | 800,000 |
2020/05 | Cost of Sales | 390,000 |
2020/05 | Gross Profit | 410,000 |
2020/05 | SGA expenses | 125,000 |
2020/05 | Operating income | 285,000 |
2020/06 | Net Sales | 500,000 |
2020/06 | Cost of Sales | 260,000 |
2020/06 | Gross Profit | 240,000 |
2020/06 | SGA expenses | 120,000 |
2020/06 | Operating income | 120,000 |
output table B
TTL Value | composition ratio | ||
Net Sales | 1,900,000 | 100.0% | |
Cost of Sales | 900,000 | 47.4% | Cost of Sales / Net Sales |
Gross Profit | 1,000,000 | 52.6% | Gross Profit / Net Sales |
SGA expenses | 400,000 | 21.1% | SGA expenses / Net Sales |
Operating income | 600,000 | 31.6% | Operating income / Net Sales |
Solved! Go to Solution.
// Base measure
[Total Value] = SUM( 'Table'[Value] )
[Composition Ratio] =
var NetSalesAmount =
CALCULATE(
[Total Value],
'Table'[DIV] = "Net Sales"
)
var Result =
DIVIDE(
[Total Value],
NetSalesAmount
)
return
Result
// Base measure
[Total Value] = SUM( 'Table'[Value] )
[Composition Ratio] =
var NetSalesAmount =
CALCULATE(
[Total Value],
'Table'[DIV] = "Net Sales"
)
var Result =
DIVIDE(
[Total Value],
NetSalesAmount
)
return
Result
Hi @gaccho_na ,
please have a look at this expample file and let me know if this helps you to solve your issue.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
14 | |
11 | |
8 | |
8 | |
8 |
User | Count |
---|---|
22 | |
13 | |
11 | |
10 | |
10 |