How can created a measure/column using separate measures in other tables

[Anonymous]

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

[Anonymous]

Creating a measure table in Power BI is easy and straightforward. Here are the steps you need to follow:

1. Create a new table in the data model.
2. Add columns to the table for each measure you want to consolidate. Use DAX formulas to calculate the values for each column.
3. Group your measures by category by creating a new column called "Category".
4. Create a relationship between your measure table and other tables in your data model. This will allow you to use your measures in visualizations and reports.

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.

[Anonymous]

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

[Anonymous]

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.