Forum Discussion
Creating Income State and Profit and Loss Analysis in Power BI
Hi, Godseyma
First of all, if you are new to Power BI and you want to create financial reports, I recommend you to download the official sample case PBIX file for report learning.
Get samples for Power BI - Power BI | Microsoft Learn
You can learn some common practices from these sample pbix files, such as how DAX expressions are written when implementing YTD, and how filters are set up when making them. Before implementing these steps, you need to get your data ready and make sure that it can be effectively utilized in your report. If you encounter the realization of YTD/QTD Income and other DAX will not write, I recommend you to read the following article:
Week-related calculations – DAX Patterns
I found the following article that matches your description, you can also read how the author designed his report when realizing the same requirement:Income Statements (Profit & Loss) in Power BI ⚡️ UPDATED GUIDE | Zebra BI Webinar (youtube.com)
Through comprehensive learning, you will then determine the design process for your reports, as well as evaluate which of the paged reports and Power BI reports better meets your real-world needs.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Godseyma
First of all, if you are new to Power BI and you want to create financial reports, I recommend you to download the official sample case PBIX file for report learning.
Get samples for Power BI - Power BI | Microsoft Learn
You can learn some common practices from these sample pbix files, such as how DAX expressions are written when implementing YTD, and how filters are set up when making them. Before implementing these steps, you need to get your data ready and make sure that it can be effectively utilized in your report. If you encounter the realization of YTD/QTD Income and other DAX will not write, I recommend you to read the following article:
Week-related calculations – DAX Patterns
I found the following article that matches your description, you can also read how the author designed his report when realizing the same requirement:
Income Statements (Profit & Loss) in Power BI ⚡️ UPDATED GUIDE | Zebra BI Webinar (youtube.com)
Through comprehensive learning, you will then determine the design process for your reports, as well as evaluate which of the paged reports and Power BI reports better meets your real-world needs.
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.