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
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
In this blog, I’m going to compare Power BI calculated column and measures, and then cover some of their differences. I’m also going to show you optimal situations where you can use either of them. Creating Calculated Columns I’m going to start by creating a calculated column in Power BI. This is probably what you’re
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. Different data sources within your models need to have the right relationships to yield the right results. When you fail to understand the concept of these relationships, you will never get
In this tutorial, I’m going to teach you how to manage multiple date calculations in your Fact Table in Power BI. This is a frequent question in the Enterprise DNA Support Forum. These multiple dates could be order dates, ship dates, expiration dates, and arrival dates, among many others. This information might be located within
