IntroductionI was wondering how I could improve building DAX expressions and one way to do that is by using DAX Studio. DAX Studio gives you a richer developer experience than the standard DAX expression editor in PowerPivot.
On the blog of Marco Russo on SQLBlog.com you can find more information about using DAX Studio for building DAX expressions.
Define MeasureIn order to use this technique you have to use the following pattern to make it work:
1. Define the measure.
2. Use this measure in you calculation.
Here is an example:
DEFINE MEASURE Sales[MTDInvoicedSales] = CALCULATE([TotalInvoicedSales], DATESMTD(Calendar[Date])) EVALUATE SUMMARIZE ( Sales, Calendar[YYYYMM], "InvoicedSales", Sales[MTDInvoicedSales] )
And below depicted in a printscreen:
ConclusionUse DAX studio when you are developing DAX Expressions with PowerPivot in Excel.