Tag: lookup table

Building Your Data Model Relationships In Power BI

Building Your Data Model Relationships

In today’s tutorial, I want to highlight how important it is to build your data model relationships correctly. Data modelling is one of the foundations of your Power BI report so it’s necessary to set it up correctly. Previously, I discussed some techniques that can help you manage your model right. One of them is

Continue reading

What Are The Different Data Table Types In Power BI?

What Are The Different Data Table Types

In today’s blog, I want to teach you all about data table types. It’s important to understand how the tables work so you can build your data model effectively. A data table contains columns and rows of information used to achieve easier visual representation. There are two types of tables within a data model: the

Continue reading

Power BI Calculated Column vs Measure: A Comparison

In this blog, I’m going to compare Power BI calculated column and measures, and then cover some of their differences. You may watch the full video of this tutorial at the bottom of this blog. I’m also going to show you optimal situations where you can use either of them. Creating Calculated Columns I’m going

Continue reading

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

Create A Lookup Table From Subtotals: Optimization In Power BI

In this tutorial, we’ll go through a technique that will create a lookup table from subtotals using the query editor in Power BI. You may watch the full video of this tutorial at the bottom of this blog. This is most useful when we’re getting data out of Microsoft Excel because most of its data

Continue reading