Tag: Query Editor

How To Set Up Your Financial Data in Power BI

Financial reporting is a very essential tool to communicate past successes as well as future expectations in a company. When you need to complete a financial analysis, you need to set up your financial data in Power BI in a compelling way. It doesn’t matter if your data is from the revenue side, the expense

Continue reading

My Practice Tips When Using The Power BI Advanced Editor

We’re going to talk about some of my best practice tips using Advanced Editor inside Power BI. Surprisingly, most people don’t know about the Advanced Editor. It is because it’s hidden away inside the Query Editor, which a lot of users don’t utilize as much as they should. If you don’t know what it is, you

Continue reading

Power BI Query Parameters: Optimizing Tables

Query parameters are a really strong feature in Power BI. There are many places that you can implement filters in Power BI, but on some occasions, it’s better to do this at the query layer versus the report level. You might want to create filters at the query level if you have massive tables from

Continue reading

Build A Comprehensive Date Table In Power BI Really Fast

Enterprise DNA Power BI Video Tutorial Create a Detailed Date Table Fast

In this post, I’m going to show you what is probably the quickest and most effective way to create a detailed date table in Power BI. If you want to analyze anything over time, there is likely no more important table to create for any Power BI model than a great date table. Creating The

Continue reading

Unpivot And Pivot Basics In Power BI – Query Editor Review

There are many occasions where you may bring data into Power BI and the data structure is not optimized for your data model. In this article, I’m going to work through when you should utilize the unpivot or pivot feature within your data queries. One thing to bear in mind early on when working on

Continue reading