Tag: ALL Function

Expanded Tables In Power BI

working with expanded tables

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

Continue reading

CALCULATE Function – How It Can Affect Your Calculations On Power BI

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

Continue reading

DAX Optimization: Where To Find The Hidden DAX Trap

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

Continue reading

Ranking Analysis In Power BI: Advanced Insights From Combined Data Sets

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

Continue reading

Vendor Analysis In Inventory Management Dashboards

Vendor Analysis In Inventory Management Dashboards

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

Continue reading