In this tutorial, we are going to take a look at a very specific scenario that I’m sure all of you have already encountered while working with DAX – the expanded table. Expanded tables can mess up your calculation if you don’t know how they actually work. You can watch the full video of this
In this tutorial, I want to show you what the CALCULATE function can do through a few examples. CALCULATE is one of the most frequently used functions in Power BI. It dictates the context being applied to any measure and removes any existing filters in place. Using CALCULATE Function For Total Sales To truly understand
I want to focus today on something I call the hidden DAX trap. If you encounter this situation, it will make you feel like you’re losing your mind because your DAX is going to look right, but it’s not going to work. I’ll walk you through when that occurs and what you can do about
In this tutorial, I’m going to show you some advanced ranking analysis in Power BI. As an example, I’m going to use the report that I submitted for the 10th Power BI Challenge on the Enterprise DNA forum. I have discussed the other pages in this report in other tutorials. For now, I would like
In this tutorial, you’ll learn how to add elements for vendor analysis in your inventory management dashboards using DAX formulas. Previous blogs have discussed how to set up the data model and the code used to get stock reorder analysis. The next details you need to focus on are the vendor tables. You have a
