Model validation for DAX measures
Please put in C:\temp or change the JSON folder
This is in progress and may not be fully functional.
The tool will validate your current model against validated numbers stored in a CSV. It is written in PowerShell as I hope to integrate into a DevOps pipeline.
The validation file should be a csv with the headers:
-ID
-Measure
-Value
ID is a reference. Measure should be the measure validating. Value is the validated value.
The remaining columns should be in format table[coulmn] e.g. Product[Category]
Fill in the values for a filter or leave blank to not apply filter.
Example:
