For today’s blog, I’ll cover measure tables and subfolders. We’re going to set up measure tables, and then I’ll show you how to group measures and subfolders to help you organize measure tables that can get pretty crowded. But before I do that, let’s go to the Enterprise DNA forum. Once you get to the
In this post, I will show you some Power BI tips and techniques on finding the previous value that accounts for weekends and holidays. This came up in a post by Brian Julius in the Enterprise DNA forum. The developer of this report wanted to calculate the percentage difference. However, the developer didn’t want to
For this tutorial, I want to discuss techniques in managing the relationships between the tables inside your data model. There are a lot of things that you need to remember to make your data model work effectively inside Power BI. It’s important to create a well-developed data model to help you communicate your business information
I want to go over some of the best practices in optimizing your rows and columns inside the Query Editor. You can optimize your table so that when you create visualizations, you’ll be able to recognize your columns easily. One of the best ways to develop the most intuitive Power BI model is to simplify
Using variables is a great way to make sure that your results add up the way they should at the end of your measures. Variables are such a crucial part of writing and solving formulas inside Power BI and I’m going to show you why. Sample Data Visualized In Gantt Chart To showcase the importance
