Tag: Power BI Data Model

Power BI Query Editor: Row & Column Transformations

Power BI Query Editor Row and Column Transformations

In this tutorial, we’ll discuss essential transformations within Power BI Query Editor that can be used to optimize your rows and columns. In developing an intuitive Power BI model, it’s best to simplify your rows and columns inside your table. Optimizing your table is essential in creating visualizations, so you can easily recognize your data.

Continue reading

Evaluation Context In DAX Calculations

Evaluation Context In DAX Calculations Power BI Enterprise DNA

In this tutorial, we’ll learn about evaluation context in DAX. Evaluation or initial context is the environment from which your dynamic calculation is based from. It’s important to understand how evaluation context works and how it affects your DAX calculation. So in the next section, I want to show you the different ways to create

Continue reading

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