Forum Discussion
Measure to add data & Values to Column
Hi There,
I am creating a P&L statement. My Raw data is set up in three columns, P&L Line, Categaory and Actual (value).
My issue is having to add Net Sales to the data and have it fit in the matrix. Is there a way to take one option in the "p&L" Column and subtract it by another in the P&L Column but have it flow like it was already in the column?
Below you will see how it is set up. I would like the "Net Sales" to be below the SR&A (Net = Gross - SR&A)
Is this possible, or must I create a new tile for Net and start a new one for Materials?
Note Net sales is not an option in the P&L line.
Anonymous There are lot more solutions on how to create P&L in Power BI, it is not that straightforward to answer. I would recommend searching for youtube on this topic and implement the solution.
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
1 Reply
- parry2k
Super User
Anonymous There are lot more solutions on how to create P&L in Power BI, it is not that straightforward to answer. I would recommend searching for youtube on this topic and implement the solution.
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡