I have consolidated 3 reports into one through power query. Now I want to make it as P&L inside this power query so I can see all income in first rows followed by all expenses. I need the total income, expenses and operating result too. I have used the Power Query inside Excel. In the attached image there are more rows for income and expenses under in original file. I need total income and expenses in all value column started from Column H.
🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.
✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.
❤️ Please consider giving it a Like, If the approach was useful in other ways.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Share
Report
All responses (
Answers (
5,013
