Created
February 1, 2023 03:05
-
-
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
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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