Tag: DAX

Calculating Percent Profit Margins Using DAX in Power BI

Working out your profit margins in Power BI with a basic data set can seem like it requires a few steps. Maybe you think you need to use calculated columns to get the result. Well, you certainly don’t need to do that. There is a much simpler way. Using measures, you can start with simple

Continue reading

Using Variables in Power BI – A Detailed Example

How To Use Variables In DAX Power BI

In this post, I’ll show you how to use variables within your DAX formula in Power BI. Variables are a real game-changer for the formula bar in Power BI. Being able to break down your more complex formulas in steps makes setting them out much more intuitive. I keep thinking back to using VBA with

Continue reading

Using SAMEPERIODLASTYEAR To Compare The Difference Between This Year & Last Year

Using SAMEPERIODLASTYEAR To Compare the Difference Between This Year & Last Year

In this post, I run through how to use SAMEPERIODLASTYEAR, a time intelligence function, to compare results from this year with those of last year. If you want to start creating compelling reports with strong insights into information over time, then you’ve got to know how to use all the variations of time intelligence functions.

Continue reading

Show Results Up To Current Date Or A Specific Date In Power BI

In this tutorial, I’m going to show you a very simple technique where you can show data up to a specific date or just up to today inside of your Power BI reports. This came from a recently requested question from the Enterprise DNA Support Forum, Personally, I’ve also used this technique many times so

Continue reading

How To Calculate The MEDIAN Value In Power BI Using DAX

Calculate The MEDIAN Value In Power BI - Statistical Analysis wDAX

In this tutorial, I want to show you how we can calculate the median value from a list of values that we have inside of Power BI. With a lot of the statistical functions that we can use in DAX, there is a need to understand how they calculate and how they operate over tables

Continue reading