Financial Reporting & Analysis with Power BI - Converting Single Column (Positive & Negative) values GL to Debit & Credit - Power BI

Part 1 of the video: https://youtu.be/QlaSMQLBHZo Lecture file link: https://www.dropbox.com/s/q6b79q0han7p2li/Lecture%2070.%20Converting%20GL%20from%20DR%20CR%20to%20PO%20NE.pbix?dl=0 Full course link: Course link: https://bit.ly/3HLXSGm Power BI automatically Year-Quarter-Month-Date hierarchy from the Date field. However, it only works for the calendar year. If the Financial Year of a business is different from the Calendar Year, we will have to manually make the date hierarchy. Accountants and Finance professionals have to prepare and analyze financial statements and finance data almost every single day. But, modern data analysis require sophisticated computer programs to handle large volumes of data and to unlock the hidden information in this data. This video series is to help you learn to use the most powerful data analysis and business intelligence program, Power BI, prepare financial statements and perform analytics to unlock the hidden patterns in the data. What is Power BI: Power BI is the world number 1 Business Intelligence tool. If you need to analyze data, Power BI will be the easiest, most comprehensive, and most recognized software program. And, it has a free version! Topics Covered: Introduction to Power BI Preparing basic analytics and visualizations in Power BI Preparing Profit & Loss Statement Full course on Udemy also covers the following: Preparing Balance Sheet Preparing Cash Flow Statement Preparing Statement of Changes in Equity Calculating key Financial Ratios Preparing Financial Dashboards #ProfitandLoss #ProfitandLossStatement #BalanceSheet #PowerBI #FinancialReporting #FinancialAnalysis #DAX #Accounting #Bookkeeping #FinancialStatements #IFRS #IncomeStatement #ProfitandLossStatement