Forum Discussion
Creating custom rows for addition and subtration
lux4545 , I have achieved this using additional row in dimesion
please check
Power BI How to get the P&L formatting right: https://youtu.be/C9K8uVfthUU
Power BI How to get two columns format Profit and Loss Statement(P&L) right: https://youtu.be/WLg85yiMgHI
https://medium.com/microsoft-power-bi/power-bi-formatted-p-l-with-custom-sub-totals-and-blank-rows-e39ca822908a
To add additional context, my data is coming from a database not excel. There are thousands of rows and I cannot simply make each line item a separate column and then create a calculated field from there. I watched the youtube videos but it looks like fields are being calculated in excel verus query. The formatting portion is helpful for the youtube videos though-I did not know how to do that.
Any other ideas or if I need to clarify in more detail, please let me know
lux4545 , Usually when something is not available in dimension we try to add that value.
Assume I have an account table
Account Id, Account Name
1, A
2, B
I need an account C that is missing
Then I will create table using enter data or Source SQL or excel having data
Account Id, Account Name
3, C
Then I will append the two to have dimension
One does not need to have extended dimensions as I have, but you need a Dimension/master table
In the actual project I have appended the tables to have additional rows(The second table was manually data entry for around 15 columns)