A Deep Dive Into The TREATAS Function In Power BI

In this tutorial, we’ll dive into one of the most advanced DAX functions in Power BI called the TREATAS function. If you can understand TREATAS, you’ll see that it has so many applications for you across all reports and dashboards which you’ll be creating inside Power BI. TREATAS allows us to simplify our model but

Continue reading

Basket Analysis Introduction – Best Practice Tips For Power BI

Today, I’m going to introduce the amazing things that you can do with the basket analysis technique. With Basket Analysis inside Power BI, you can try to analyze the customer sales of one grouping of products versus another grouping of products. There’s plenty of application for this across Power BI. But for this tutorial, I

Continue reading

Creating Virtual Relationships In Power BI Using The TREATAS Function

The TREATAS function in DAX is one of the most interesting DAX formulas that you can utilise inside your Power BI models. It has a very specific usage that can be beneficial if you are looking to simplify your data model and DAX formulas. In this tutorial, I’m going to show you how we can

Continue reading

Using Power BI DAX Functions To Deal With Products That Have Changing Prices Overtime


In this blog post, we are going to work through an advanced but real-world analysis involving Power BI DAX functions. The scenario in question is when you have products which change prices over time. A lot of the demos/showcases you have reviewed over time suggests that a product’s price stays exactly the same from the

Continue reading