Skip to content

Instantly share code, notes, and snippets.

// configurations start
Today=Date.From(DateTime.LocalNow()), // today's date
FromYear = 2015, // set the start year of the date dimension. dates start from 1st of January of this year
ToYear=Date.Year(Today), // set the end year of the date dimension. dates end at 31st of December of this year
StartofFiscalYear=7, // set the month number that is start of the financial year. example; if fiscal year start is July, value is 7
firstDayofWeek=Day.Monday, // set the week's start day, values: Day.Monday, Day, Sunday....
// configuration end