In today’s blog post, I want to discuss how you can build additional data dimensions in Power BI. These dimensions can help you filter your data in different ways. On top of that, these dimensions can help you come up with intuitive visualizations later on. This is also the reason why you need to set
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
For this tutorial, I want to discuss techniques in managing the relationships between the tables inside your data model. There are a lot of things that you need to remember to make your data model work effectively inside Power BI. It’s important to create a well-developed data model to help you communicate your business information
After having an extensive discussion about the query editor, it’s time to move all that data into a Power BI report through data modeling. Data modeling allows you to connect different data tables in your Power BI report by creating relationships between them. Fixing Relationships In The Core Data Model My core data model consists
In this blog, we will be discussing how to convert a YYWWD code into a Date Value. This tutorial was based on a response to a query of an Enterprise DNA Support Forum member. The member asked for a way to convert his Confirmed delivery date field, which is in a year, week, and day of
