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. You may watch the full video of this tutorial at the bottom of this blog. But before

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. You may watch the full video of this tutorial at the bottom of this blog. The developer

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. You may watch the full video of this tutorial at

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. You may watch the full video of this tutorial at the bottom of this blog. 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

Continue reading