Forum Discussion
Power BI Add New Rows in a Matrix
Hi Everyone ,
i created a new matrix table as you can see below .Originally in my product table there are product1,product2,product3 products .i would like to add new products (i marked yellow and green line)
Product_1_3=Product1+product3
product_2_3 = product2+product3
Can someone help me about this?
Regards,
1 Reply
Hi alanuxx ,
I am attaching a pbix with a similar use case. In the original data, Net Income is not in the main table and is to be computed using the Revenue/Expenses/Other Expenses data. I used a disconnected table (no relationship to fact table) to hold Group names (Product Name in your case) and a measure to return the value for each. There is also another calc table to return the Group names from the original table with an extra row for Net Income appended to it.
