DAX-week by week comparison and YTD,QTD,MTD calculations RRS feed

  • Question

  • Hi, I need to use DAX to perform week by week comparison and do YTD,QTD,MTD calculations of a number of measures. If possible, the date calculations (YTD,QTD,MTD) should not be based on any specific measures.   

    I have a Date table with the CalendarDate, Fiscalyear, FiscalQuarter,  FiscalMonth, FiscalWeekStartDate, and FiscalWeekEndDate columns. What would be a good approach to do this?

    Friday, November 9, 2012 12:56 AM


All replies