bi-luxstay

let
    // 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
    FromDate=#date(FromYear,1,1),
    ToDate=Today,