Likely whenever you’ve heard an explanation of how to use variables within DAX, you will have heard the phrase “variables are constants”. It seems simple on the face of it, but there’s actually a fair amount of nuance and complexity bundled up in these three words. This video walks through exactly what this phrase means, and the implications for how your measures are calculated. Understanding these concepts is essential to ensuring that your measures produce the desired results.
Attached are the supplementary files that I refer to in the video. You can use these to explore the details of the scenarios I present on your own.
– Brian
eDNA Video 30 - Variables are Constants.pbix (6.2 MB)
eDNA Forum - Previous Value Solution - no weekends or holidays (1).pbix (6.3 MB)