Tag: TREATAS Power BI

The Ultimate Budget Allocation Formula For Power BI Analysis

In this tutorial, I’m going to show you the ultimate Budget Allocation formula that you can use when dealing with amounts and data of different granularities. You may watch the full video of this tutorial at the bottom of this blog. Your Budgets could be at a monthly, quarterly, or yearly granularity while your Sales

Continue reading

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. You may watch the full video of this tutorial at the bottom of this blog. If you can understand TREATAS, you’ll see that it has so many applications for you across all reports and dashboards

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. You may watch the full video of this tutorial at the bottom of this blog. In most cases, budgets are in a yearly basis. However, it’s so much

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. You may watch the full video of this tutorial at the bottom of this blog. It has a very specific usage that can be beneficial if you are looking to simplify your data

Continue reading

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

DEALING W/ PRODUCTS WHERE PRICES CAN CHANGE

In this blog post, we are going to work through an advanced but real-world analysis involving Power BI DAX functions. You may watch the full video of this tutorial at the bottom of this blog. The scenario in question is when you have products which change prices over time. A lot of the demos/showcases you

Continue reading