I’m going to show you how to use the offset function in Power BI. It’s one of the most dynamic tools you can use especially in your date tables. Once you master how to apply it in your time intelligence projects, you can get more in-depth insights that you won’t get using any other approach.
In this tutorial, you’ll learn how to perform data masking for sensitive information in Power BI using Power Query. Data masking allows you to hide or remove confidential or identifiable information in your Power BI data models. The discussion will focus on these points: And this basic model will be used as the example: When
The DAX (Data Analysis Expression) formula language is one of the key pillars in Power BI. Learning DAX might be overwhelming at first. But once you understand how it works, you can level up your analytical insights. The key to getting great insights in your reports is through the use of DAX calculations. For this
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