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. In this video, I’ll walk you 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.

Brian

Check out the Enterprise DNA Forum Post here: https://forum.enterprisedna.co/t/what-does-variables-are-constants-really-mean/19737?u=sam.mckay

***** Video Details *****
00:00 Introduction
02:01 Total sales
03:00 Applying variables
05:45 Common mistaking when using variables
06:22 Iterators
07:05 Using variables to mark current row

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial