Forum Discussion

Chanleakna123's avatar
Chanleakna123
Post Prodigy
2 years ago

Calculate MTD,

Hi , I'm very struggling on calculated the data using MTD performance,  i would like to compared MTD in monthly to see the real performance.  What i'm having right now is always showing MTD data vs...
Show and Tell
Daniel29195's avatar
Daniel29195
Community Champion
2 years ago

hello Chanleakna123 

you can use this measure : 

 

Measure 9 =
CALCULATE(
    [Revenue],
    SAMEPERIODLASTYEAR(DATESMTD('Date Table'[Date]))
)

 

or you can use : 

Measure 9 =
CALCULATE(
    [Revenue],
    dateadd(DATESMTD('Date Table'[Date]),-1,YEAR)
)

 

 

 

let me know if it works for you .

 

 

 

 

If my response has successfully addressed your issue kindly consider marking it as an accepted solution! This will help others find it quickly. Dont forget to hit thumbs up buttton 👍

 

Chanleakna123's avatar
Chanleakna123
Post Prodigy
2 years ago

it's accumulated each other , which is not right 

 

 

  • Daniel29195's avatar
    Daniel29195
    Community Champion
    2 years ago

    Chanleakna123 

    if you want the same day last year, 

    then modify the measures to this : 

    Measure 9 =
    CALCULATE(
        [Revenue],
        dateadd('Date Table'[Date],-1,Month)
    )

     

    or you can use : 

    Measure 9 =
    CALCULATE(
        [Revenue],
        dateadd('Date Table'[Date],-1,YEAR)
    )

     

     

    let me know if this works for you . 

     

    if it still doesnt work,  plesae share a sample of your pbix file to take a closer look . 

     

    best regards,