Forum Discussion
Calculate difference between 2 categories with multiple columns in power bi
I would like to add another row called "profit" which is the difference between Margin and expense.
Sales , Margin and Expense comes from a dimension table.
2 Replies
Anonymous , if they are dimension profit need to dimension. You can not add a row below in the Matrix
But this article might help : https://community.powerbi.com/t5/Desktop/Traditional-Financial-Statements/td-p/7223
Hi Anonymous ,
Can you provide detailed data models and information for me to do further testing? Let me know immediately, looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
