Tag: Power BI Tips

Creating Measure Tables & Subfolders In Power BI

Creating-Measure-Tables-AND-Subfolders-In-Power-BI

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

Continue reading

Power BI Tips: Retrieving Previous Value Excluding Weekends & Holidays

Power BI Tips Retrieving Previous Value Excluding Weekends and Holidays

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

Continue reading

Techniques To Manage Your Data Model In Power BI

Techniques To Manage Your Data Model in Power BI

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

Continue reading

Row And Column Transformations In Power BI

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

Continue reading

Why Using Power BI Variables Is A Better Way To Write DAX Measures

Why Using Variables Is A Better Way To Write DAX Measures - Power BI Admin Advice

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

Continue reading