Tag: DAX Measures

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

What Is DAX? Understanding Its Meaning, Importance And Use

Once you understand transformations and data modeling, you can finally start working on visualizations on your reports. This would require a deeper understanding of DAX. What Is DAX? What is DAX and why is it important? DAX stands for Data Analysis Expressions. DAX is the formula language within Power BI. This is where Power BI’s

Continue reading

Creating A Currency Conversion Table In Power BI

In this tutorial, we’re going to learn how to create a currency conversion table for Sales in Power BI using DAX measures. Using this technique, we would only need to create a simple slicer to convert a currency to another. This is especially useful when dealing with data containing multiple currencies in Power BI. For

Continue reading