Tag: USERELATIONSHIP

Active And Inactive Data Relationships In Power BI

Active And Inactive Data Relationships

Previously, I discussed the importance of data model relationships in Power BI. I also introduced the one-to-many and many-to-one relationships. Now, I’ll teach you about the difference between active and inactive data relationships. These are important concepts that you need to be familiar with in data modelling. In this example, you can see that the

Continue reading

Supply Chain Management Techniques In Power BI

Managing Your Supply Chain Data w/Power BI - Analysis Techniques

I recently ran a workshop on Supply Chain Management and I want to discuss the key insights from the session. This tutorial can be of great help if you have exposure to this kind of analysis in Power BI. Supply chain management happens within a certain business operation that involves the flow of goods and

Continue reading

Manage Multiple Date Calculations In Your Fact Table – Advanced Power BI Technique

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

Continue reading

How To Work With Multiple Dates In Power BI

As soon as you start developing a few Power BI models, you’ll very likely run into a problem where you have two dates in your fact table and you can’t place two relationships between your date table and the other table. You might even have multiple dates, like entered date, ordered date, invoiced date, shipped

Continue reading