In this tutorial, I’ll be teaching the Profit and Loss, or P&L statement, in Power BI. I’ll show you how to create a table or matrix of financial information. This technique is perfect for financial reporting, especially for those who are in the finance field such as accountancy firms. I recommend doing this in Power
Tag: Power BI Techniques
In this tutorial, we’ll go over the Natural Language Query (Q&A) feature in Power BI. There’s so much you can discover just by writing these Google-like queries inside the search bar and dashboards in Power BI. This feature isn’t just for simple queries. It can also be used for very advanced insights that you have
In this tutorial, we’ll look at a unique technique inside Power BI that allows us to create dynamic ranking tables using the RANKX function. What are Dynamic Ranking Tables? Dynamic Ranking Tables showcase a range of information dynamically in a table, but the information shown is based off a specific ranking on a singular calculation.
I’m going to show you something specific and quite advanced on budgeting through Power BI. We’re going to dive into how to create budgets with consideration on seasonal impact. This has great potential mostly because it paves the way for highly effective analysis. It also enables you to automate some of the insights that you
In this unique example, I want to show you how to project a historical trend in Power BI and repeatedly project it forward. This particular example came from a question in the Enterprise DNA support forum. An Enterprise DNA member needed to carry out this analysis in the real world using historical information, which could