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