Tag: Virtual Relationships Power BI

Connecting Data Tables – Tips on Power BI Relationships

Now that I’ve discussed what data modeling is, it’s time to understand what Power BI relationships among different tables can do for your reports. You may watch the full video of this tutorial at the bottom of this blog. Different data sources within your models need to have the right relationships to yield the right

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