I have been giving support for DAX in different places. Something that is becoming more frequent are long DAX functions repeating code (they might be format, but long). Usually, these problems arrive when there is a performance issue that results in a long measure.
In this article I’m going to explain with my words the importance of using variables in our code. We should always consider using variables because they have several benefits. Some people might think they only help to make the code feel cleaner, but I can assure you it will help on maintainability too.
Read more...