Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have created seaparate measures for P&L using GL and Account Mapping table.
Measure 1 - Revenue
Measure 2 - Gross Profit
Measure 3 - SG&A
Measure 4 - EBITDA
I have to create a income statement / P&L summary visual table
Column 1 | Column 2 | Column 3
Category | Actuals | Budget
Revenue | XXXX | XXX
Gross Profit | XXXX | XXX
SG&A | XXXX | XXX
EBITDA | XXXX | XXX
Is there a way to combine separate measures into one table/Measure.
Data Model Structure:
GL Table
Account Mapping
Budget Table
Date Table
Please if there is any other solution.
Thanks
Creating a measure table in Power BI is easy and straightforward. Here are the steps you need to follow:
New Table =
UNION (
ROW ( "Category", "Revenue" ),
ROW ( "Category", "Gross Profit" ),
ROW ( "Category", "SG&A" ),
ROW ( "Category", "EBITDA" )
)
Replace the XXXX and XXX placeholders with the actual values for your measures.
How to Put All Measures in a Single Table in Power BI - Zebra BI
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Thank you for the quick response.
I couldnt undersatnd the 2nd step and how can I group the measures. Can you kindly check?
Thanks
Hi @Anonymous ,
There are more details in the document, please refer to.
How to Put All Measures in a Single Table in Power BI - Zebra BI
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |