Hi - I have the below very useful code taken from Havens consulting. Was wondering if anyone had used this but with a financial YTD instead of calendar YTD? Our FY ends in June.
/*
* Generate time intelligence measures based
*
* Modified by: Reid Havens, https://havensconsulting.net
* Original Author(s): Benoit Fedit, https://datakuity.com
* Original Author(s): Bernat Agulló, www.esbrina-ba.com/blog
*
*/
// Creates popup promots to select the calendar table, and date column, to then dynamically update the scripts below
var CalendarTable = SelectTable(label: "Select your calendar table");
if(CalendarTable == null) return;
var CalendarTableDateColumn = SelectColumn(CalendarTable.Columns, label: "Select the date key column");
if(CalendarTableDateColumn == null) return;
string CalendarTableName = CalendarTable.Name;
string CalendarTableDateColumnName = CalendarTableDateColumn.Name;
// For each selected measure create YTY, PY, PY YTD, YOY, YOY% measures
foreach(var m in Selected.Measures) {
// YTD
m.Table.AddMeasure(
m.Name + " YTD", // Name
"\r\n" + // Carriage Return
"CALCULATE(" +
"\r\n" + // Carriage Return
" " + m.DaxObjectName + "," +
"\r\n" + // Carriage Return
" DATESYTD( '" + CalendarTableName + "'[" + CalendarTableDateColumnName + "] )" +
"\r\n" + // Carriage Return
")",
".Time Intelligence\\" + m.Name // Display Folder
);
Hi
