Tags

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,


DAX Parameter Replacer and Beautifier – Free Tool

Data Analysis Expressions (DAX) is a language introduced by Microsoft in Power Pivot and Analysis Services Tabular to define calculations and queries.

Download Free Tool – DAX Parameter Replacer and Beautifier

DAX Parameter Replacer and Beautifier is a free tool.

It majorly does 2 things-
1. It replaces all your parameters with their values.
2. It transform your DAX formulas into beautified code. Thanks to Nick Medveditskov for writing free web service (http://blogs.msdn.com/b/business_intelligence_labs/archive/2011/09/13/format-mdx-amp-dax-web-service-for-formatting-is-available.aspx )

We have created this utility to help developers works in Analysis Services with Tabular Model and reporting services. In our case we are working on Reporting Services and in the background we are using SSAS with Tabular model for data. To fetch data from Tabular cubes we are using DAX(Data Analysis Expressions). We have around 20-30 parameters per report and it is very difficult to replace values one by one manually and open a site for beautifying DAX ( for Readability purpose ). This utility will save your development time as you can easily replace your parameters ,beautify dax and copy the output very quickly and run on tabular model.

Sample Images of the utility are given below-

DAX Parameter Replacer and Beautifier - Pic 1

DAX Parameter Replacer and Beautifier – Pic 1

DAX Parameter Replacer and Beautifier - Pic 2

DAX Parameter Replacer and Beautifier – Pic 2

DAX Parameter Replacer and Beautifier - Pic 3 (Formatted DAX)

DAX Parameter Replacer and Beautifier – Pic 3 (Formatted DAX)

As always, I appreciate any comments or feedback.

Enjoy!

Vikas & Pawan

Advertisements