Tag: TREATAS Function

Budget Allocation: Monthly Forecasts Across Daily Results In Power BI

In this tutorial, I’ll go through a budget allocation technique in Power BI where you allocate Budgets at a monthly level versus Sales or Transaction Data at a daily level. This scenario is very common when working with any type of forecasted information. As an example, you may have Sales that happen every day, but

Continue reading

Power BI Budgeting Technique: Allocating Monthly Budgeting Sensitivity Table

In this blog, I talk about a technique around Power BI budgeting, working out a way to allocate calculations across different time frames or months, for example. In most cases, budgets are in a yearly basis. However, it’s so much better to narrow it down to a monthly basis and see the allocation of our

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