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
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
In this example, we’re doing a deep dive into budgeting and forecasting inside of Power BI. Specifically, I want to show you how you can allocate budgets (or forecasts) which might be at a monthly or a yearly level, and you need to allocate them to a daily level. This scenario is very common when
