Tag: DAX Calculations

DAX Calculations In Power BI: Best Practices

DAX Calculations In Power BI- Best Practices

This tutorial will feature the best practices for DAX calculations when developing reports in Power BI. You may watch the full video of this tutorial at the bottom of this blog. DAX calculations are one of the four pillars of Power BI development. In this post, you’ll learn tips on how to maximize your DAX in order to obtain

Continue reading

Time Comparisons In Power BI: This Year vs Last Year

Time Comparisons In Power BI: This Year vs Last Year

I want to go over how you can easily do time comparisons in Power BI and specifically calculate this year versus last year. I’m going to show you a couple of techniques that you can utilize for time comparisons like this. You may watch the full video of this tutorial at the bottom of this

Continue reading

Power BI Holiday Calendar – Calculate Date W/DAX

Creating a Power BI holiday calendar is crucial for many time intelligence calculations. In this tutorial, I’m going to show you how to calculate specific holiday dates using DAX measures. You can watch the full video of this tutorial at the bottom of this blog. This example came from one of the Enterprise DNA initiatives

Continue reading

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. You may watch the full video of this tutorial at the bottom of this

Continue reading