private static async Task FormatMultipleRequests()
{
var formatter = new DaxFormatterClient();
var request = new DaxFormatterMultipleRequest
{
DatabaseName = "MyDatabaseName",
ServerName = "MyServerName",
ListSeparator = ',',
DecimalSeparator = '.',
MaxLineLength = DaxFormatterLineStyle.LongLine,
SkipSpaceAfterFunctionName = DaxFormatterSpacingStyle.BestPractice,
ServerMode = Dax.Formatter.AnalysisServices.ServerMode.Tabular,
ServerType = Dax.Formatter.AnalysisServices.ServerType.AnalysisServices,
ServerEdition = Dax.Formatter.AnalysisServices.ServerEdition.Enterprise,
ServerLocation = Dax.Formatter.AnalysisServices.ServerLocation.OnPremise,
};
request.Dax.AddRange(DaxMultipleExpressions);
var responses = await formatter.FormatAsync(request);
foreach (var response in responses)
{
Console.WriteLine(response.Formatted);
}
}
private static async Task FormatSingleExpression()
{
var formatter = new DaxFormatterClient();
var response = await formatter.FormatAsync(DaxSingleExpression);
Console.WriteLine(response.Formatted);
}
private static async Task FormatMultipleExpressions()
{
var formatter = new DaxFormatterClient();
var responses = await formatter.FormatAsync(DaxMultipleExpressions);
foreach (var response in responses)
{
Console.WriteLine(response.Formatted);
}
}
private static async Task FormatInvalidExpression()
{
var formatter = new DaxFormatterClient();
var invalidExpression = "[X] := SUMX ( Sales[Amount] ), )";
var response = await formatter.FormatAsync(invalidExpression);
Console.WriteLine($"Formatted '{ response.Formatted }' ");
foreach (var error in response.Errors)
{
Console.WriteLine($"Line { error.Line }, Column { error.Column }, Message { error.Message }");
}
}