Tag: DAX Functions

Check Out Our Re-Imagined DAX Formula Reference Guide

We’ve been working on a huge project at Enterprise DNA. We’ve deeply thought about and then re-imagined how you could create a better DAX formula guide.  And we have finally completed it and ready to release it to all those connected to Enterprise DNA.  You can find the DAX guide within our Knowledge Base. Please check out the link below to navigate straight to it.  DAX Reference Guide

Continue reading

Using Moving Averages To Show Trends in Power BI

In this blog post, I want to dive into trend analysis. Specifically, how to highlight trends in Power BI really effectively using moving averages. The concepts that I go through here are techniques you might have already touched on yourself in the past. But I wanted to show how important it is from a visualization perspective

Continue reading

Iterating Functions In DAX Language – A Detailed Example

For this blog post, I want to dive into iterating functions within the DAX language in Power BI. The reason why I want to spend some time showing what you can do inside of iterating functions is because it’s such an important concept that you need to learn very well. You might have only just

Continue reading

Introduction to Filter Context in Power BI

Filter context is one of the major topics that any Power BI user should initially learn about, especially if you want your DAX calculations to work effectively. In this article, I will run through the filter context. Every DAX formula is calculated in a two-step process. DAX Formula: A Two-Step Process The first step is

Continue reading

Understanding Evaluation Context in Power BI

The most important concept in understanding DAX is context. There are three main types of context: the evaluation context, the filter context, and the row context. When DAX calculates something in Power BI, it works via a two-step process. At first, it evaluates the context it is currently in. Once it has done that, it

Continue reading