Tag: DAX

Show Last N Sales Of A Customer Only Using Power BI

We are going to go through quite an advanced tutorial here utilizing┬áDAX formulas in Power BI What I want to show you is how we can work out; how many sales we have made from a specific customer….but, we only want to look at the last three sales or last N number of sales rather

Continue reading

How To Create Virtual Relationships Using TREATAS In Power BI

How To Create Virtual Relationships Using TREATAS In Power BI

The TREATAS function in DAX is one of the most interesting DAX formulas that you can utilise inside of your Power BI models. It’s only been around for the last couple of years and it has a very specific usage which can become very beneficial if you are looking to simplify your data model and

Continue reading

How You Can Predict Profitability In The Future Using Power BI

How You Can Predict Profitability In The Future Using Power BI

What I want to cover with this tutorial is an example of how you can predict profitability in the future using Power BI. I wanted to focus more on the concepts of what can be achieved here. In order to actually achieve this in Power BI, what you need is a number of different modelling

Continue reading

Budgeting Performance Segmentation Using DAX In Power BI

Budgeting Performance Segmentation Using DAX In Power BI

When working on budgeting analysis inside of Power BI, there may be situations in your work where you want to segment the results into different groups, so that you can analyse which performers were better than others, versus their targets for example. This is some very unique analytics that can be done inside of Power

Continue reading

Find Out How To Quickly Create Virtual Groups In Power BI

Find Out How To Quickly Create Virtual Groups In Power BI

Did you know there is a way to create groups virtually in Power BI? I was so happy when I discovered this, as it allows you to quickly and effectively create another grouping dimension in your datasets or data tables. The Power BI team has made it so easy to implement and edit as well.

Continue reading