I want to insert calculated rows to a power BI matrix. How do i add this?
I can add calculated columns. But not sure how to structure the data and what are the functions to use to do this;
| 2018 | |
| Vol(KG) | 100 |
| Turnover | 12,000 |
| Cost | (8,000) |
| Gross Profit | 4,000 |
| Cost/KG | 40 |
| Gross margin | 33.3% |
This is what the matrix should look like. Cost/KG and Gross margin are calculated using above rows.
Please assist