Category: Query Editor

Compare One Sale Versus The Last Sale (No Time Intelligence)

In this unique example, I will show you how you can compare a sale, on any particular day to the very last sale that was made. This will be relevant if you don’t actually sell something every single day or if you are looking at a particular customer or a product and you want to

Continue reading

My Practice Tips When Using The Advanced Editor in Power BI

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

Optimizing Power BI Tables using Query Parameters

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

Continue reading

New Course Release – Advanced Data Transformations & Modeling

You can view details around the new course here – Advanced Data Transformations and Modeling Exciting times here at Enterprise DNA as I’m releasing yet another course into Enterprise DNA Online. The Advanced Data Transformations and Modeling course has been a work in progress for some time as I wanted to make sure that I

Continue reading