2
Vote

Automated Unit Testing

description

Allow users to create sets of unit tests that can be automatically run from Dax Studio. Each test would return "pass" when the output of the associated Dax query matched the expected output. Otherwise, the test would return "fail"
 
For simplicity, it would be nice if unit tests could be stored in a worksheet. Each unit test would include the name of the test, a description, a Dax query, and the name of another table/worksheet that contains the expected result.
 
Bonus: Optionally, Dax Editor could automatically and temporarily re-point each data source to a "test" database, refresh the model, perform the unit tests, then restore the data sources.

comments