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

Show Days Before Or After A Selected Date Using Power BI

Show Days Before Or After A Selected Date Using Power BI

As we work through this tutorial I will show you some truly powerful analytics that you can complete inside of Power BI. It is amazing how flexible you can make your solutions in Power BI if you get the set up right. When I say set up, I mean your data model first and foremost

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

How You Can Re-Use Moving Averages In Power BI

How You Can Re-Use Moving Averages In Power BI

In this particular tutorial, we are going to dive into how to showcase trends in your data using moving averages. I want to show you here though how to take this further.¬†How we can re-use the moving averages formula technique in a number of different ways. What’s great about this formula combination or formula pattern

Continue reading

Using Great Color Schemes In Your Power BI Data Visualization

Using Great Color Schemes In Your Power BI Data Visualization

Creating a high-quality colour palette inside of Power BI is essential to making your reports look compelling and very professional. I’m constantly seeing reports out there which use the generic colour palette for Power BI, which to me is a huge negative. I personally can’t stand these colours as they just don’t do you work

Continue reading