Category: Financial Reporting

Using Calculate Function Inside Power BI

Using Calculate Function Inside Power BI

For this tutorial, I’ll cover how the CALCULATE function works and why it’s so crucial in Power BI. I’ll also show you some examples of its application. You can easily branch out to time intelligence calculations by using the CALCULATE function. Once you apply this technique, you’ll be able to produce high quality insights inside

Continue reading

DAX Table Functions In Power BI

In this blog post, I’ll introduce you to DAX table functions. Table functions are simply DAX functions that return a table. Some of the most common table functions that you can encounter in Power BI are the FILTER, VALUES, and ALL functions. Using these table functions, you can create virtual tables inside Power BI. Physical

Continue reading

Understanding Power BI Aggregations

Now, let’s delve deeper into one of the most important concepts in Power BI calculations — the aggregations. Power BI aggregations are formulas used to calculate a single summarized value from multiple rows that are grouped together. There are different ways to create aggregations in Power BI. Some of the examples of aggregation functions are

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