Skip to content

Instantly share code, notes, and snippets.

@bjulius
Created February 1, 2023 03:05
Show Gist options
  • Save bjulius/8e71fde3e82574d278b9b06093583905 to your computer and use it in GitHub Desktop.
Save bjulius/8e71fde3e82574d278b9b06093583905 to your computer and use it in GitHub Desktop.
C# Script to Automatically Create MIN, MAX, AVERAGE, MEDIAN and SUM DAX Measures for all Selected Columns
// Creates a MIN, MAX, SUM, AVERAGE and MEDIAN measure for every currently selected column
foreach(var c in Selected.Columns)
{
var newMeasure = c.Table.AddMeasure(
"Min of " + c.Name, // Name
"MIN(" + c.DaxObjectFullName + ")", // DAX expression
c.DisplayFolder); // Display Folder
var newMeasure2 = c.Table.AddMeasure(
"Max of " + c.Name, // Name
"MAX(" + c.DaxObjectFullName + ")", // DAX expression
c.DisplayFolder); // Display Folder
var newMeasure3 = c.Table.AddMeasure(
"Sum of " + c.Name, // Name
"SUM(" + c.DaxObjectFullName + ")", // DAX expression
c.DisplayFolder // Display Folder
);
var newMeasure4 = c.Table.AddMeasure(
"Average of " + c.Name, // Name
"AVERAGE(" + c.DaxObjectFullName + ")", // DAX expression
c.DisplayFolder // Display Folder
);
var newMeasure5 = c.Table.AddMeasure(
"Median of " + c.Name, // Name
"MEDIAN(" + c.DaxObjectFullName + ")", // DAX expression
c.DisplayFolder // Display Folder
);
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment