Tag: DAX Calculations

Inventory Management Dashboard In Power BI

Inventory Management Dashboard In Power BI

In this tutorial, you’re going to learn the complex measures and DAX formula used to create an inventory management dashboard in Power BI. As a seller, you have to know how many products you need to re-order and stock and how much these will cost you. Use these DAX formula patterns to get those calculations

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

Introduction To Advanced DAX in Power BI

In this tutorial I want to show you some samples of Advanced DAX calculations in Power BI. After going through the basics, I’ll now demonstrate some advanced functions and formulas that are key to computing more complicated calculations. I won’t cover every formula or function, but instead I’ll give you an overview of a few

Continue reading

How To Use An Iterating Function In Power BI

This tutorial will teach you about different iterating functions and how to efficiently use them in your calculations. I often discuss how calculated columns are not required when making some calculations. This is because of iterators. Iterators or iterating functions can help you do a calculation without physically putting the results in the table. This

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