Forum Discussion
Matrix with extra forumulas - how do you do this ??
Hi All,
I hope you have a solution for this.
I have a financial transaction table and want to make a matrix like the excel example below:
Excel example
But what is the way to add some extra formules in this matrix, like :
Margin ( = Net turnover + Purchase )
- Total Costs - Operation Result and EBITDA ?
Is there a way to view this like the excel example?
This is the content of the table I imported
Regards, Bart
If nesseccary i can send a pbix example
13 Replies
PaulDBrownCommunity Champion
Hi Paul, thanks but i can't see the video link
- PaulDBrown
sorry I just fixed it
Hi Paul, its a nice video about PNL reporting, but it don't give an answers on my question if its is possible to add new rows with formulas
- PaulDBrown
To build the structure you need a table with all the rows. If that is not possible at the source, you can create the structure in Excel and import it or paste it into a table using "Enter data"(including a sorting order column) or you can create a new table by using the equivalent of the following as code for a new table option in the ribbon:
all rows =
VAR _ExtraRows = {"NewRow1", "NewRow2", "NewRow3", "NewRow4"}
RETURNUNION( DISTINCT('YourCurrent'[rows]), _ExtraRows)
In the new table you will then need to establish the row order using a SWITCH function in a new calculated column. . You can then sort the row column using the "Sort column by" in the ribbon and selecting the order column.
If you are still stuck, please share a sample PBIX file
