Summarizing custom rows

[gvg]

Hi,

Is it at all possible to summarize Table1 into Table2 in Power BI?

Would appreciate any hints how to do it.

[Zubair_Muhammad]

@gvg

Just pivot the Income Statement Items Column using Query Editor

Then you can easily Add New Custom Columns like Net Sales, EBITDA etc

Then Unpivot back the Columns

[gvg]

Well, these are tables in Power BI. I can't operate them in Power Query, can I?

[Zubair_Muhammad]

@gvg

I meant the QUERY editor.

If these are your raw data tables you can modify them using Query Editor

[gvg]

No, they are not raw tables. They are tables generated in Power BI using tools that are not available in M (parent-child hierarchy handling DAX functions like PATH, PATHITEM, etc.).