The easiest way to start using variables in #dax
A few months ago, I and Alberto realized that the reason why variables are not used in DAX as they should is that… there are not many examples out there!
For this reason, we made a commitment to use them more often in our example. We didn’t do that in 2015 and 2016 because of the larger number of Excel 2010/2013 and SSAS 2012/2014 users, but in 2017 most DAX users work in Power BI, and variables are available also in Excel 2016 and SSAS Tabular 2016. There are no more excuses.