Category: Financial Reporting

Power BI Context: A Fundamental Concept In DAX

One of the fundamental concepts that is important in building efficient reports is Power BI context. If you want to make effective analytical measures, it’s essential to learn how to manipulate the context of a certain measure. Context can help you perform dynamic analysis in Power BI. In addition to that, changing the context can

Continue reading

Getting Started With DAX In Power BI

Getting Started with DAX

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

Continue reading

Building Data Dimensions In Power BI

Build Other Data Dimensions in Power BI

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

Continue reading

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

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