MTD for Previous period

Hi Ganethra,

I believe you are trying to calculate the previous month's sales that's -1 from the current selection. I think PARALLELPERIOD and DATEADD should help calculate previous month sales. 

This does exactly what you want:

[MTD] = 
    // Please note that the Dates table must be
    // marked as a Date Table in the model.
    // MonthOrderNumber must be a unique integer
    // that identifies each month across the whole
    // calendar. So, the very first month in the
    // calendar will have a MonthOrderNumber of 1
    // and then CONSECUTIVELY up until the last month.
    // This number is used to move through months
    // easily.
    // If today is not suitable and you want the
    // day before today, just subtract 1 from
    // today() below and the rest remains the same.
    var Today_ = today()
    var TodaysMonthNumber =
        calculate(
            SELECTEDVALUE( Dates[MonthOrderNumber] ),
            Dates[Date] = Today_,
            ALL( Dates )
        )
    var SelectedMonthNumber = 
        selectedvalue( 'Dates'[MonthOrderNumber] )
    var DifferenceInMonthOrderNumber =
        CurrentlyVisibleMonthNumber - TodaysMonthNumber
    var TodaysMTDPeriod =
        CALCULATETABLE(
            DATESMTD( Dates[Date] ),
            Dates[Date] = Today_
        )
    var RequiredMTDPeriod =
        DATEADD(
            TodaysMTDPeriod,
            DifferenceInMonthOrderNumber,
            MONTH
        )
    var Result =
        CALCULATE(
            [Your Measure],
            RequiredMTDPeriod
        )
    return
        Result