Tag: Power BI Techniques

How To Create Profit And Loss (P&L) Statements In Power BI

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

Continue reading

How To Use Natural Language Query (Q&A) In Power BI

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

Continue reading

Creating Dynamic Ranking Tables Using RANKX In Power BI

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.

Continue reading

How To Create Budgets With Seasonality Impact Using Power BI

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

Continue reading

Projecting The Current Trend in Your Power BI

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

Continue reading