Tag: DAX Measures

Calculated Columns Power BI: Tips & Best Practices

Best Practices When Using Calculated Columns In Power BI

This tutorial will discuss the best practices in using calculated columns in Power BI. We’ll also be going through the DAX formulas used to create them. In previous discussions, we’ve gone through how to write different measures in Power BI, but another technique we can use is to create calculated columns. Other than measures, using

Continue reading

Quick Measures Power BI: Year-To-Date Total Calculation

In this guide, I’ll briefly discuss how to use Quick Measures in Power BI. Quick Measures allows you to create DAX measures using a point-and-click method. Additionally, it enables you to quickly explore a lot of different formulas and formula combinations. Before I dive in, I just want to say that I don’t personally use

Continue reading

Power BI And Excel: Difference In DAX Formulas

In this blog, I will quickly discuss the main difference between Power BI DAX and Excel formulas. I’ll show you some examples to help you see this better. I’m going to use the data that I used in the previous blog that tackled the differences between Measures and Calculated Columns. Let’s get straight to it.

Continue reading

Simple Power BI Measures – Beginners’ Tutorial and Best Practices

I’m going to show you some simple Power BI measures you can start with. These can give you a good foundation on what kind of insights Power BI can give you. Understanding these simple Power BI measures is key to easing into more advanced techniques later on. One thing you have to remember if you’re

Continue reading

Creating Measure Groups – Power BI Best Practices

Once you start creating measures in Power BI, it’s necessary to learn how to organize everything. Creating measure groups is one of the best ways to make sure everything is in its proper place. Measure groups are like folders where you put similar measures together. They help make the entire process seamless, regardless if you’re

Continue reading