Forum Discussion

Chanleakna123's avatar
Chanleakna123
Icon for Post Prodigy rankPost 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
Icon for Community Champion rankCommunity 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
    Icon for Post Prodigy rankPost Prodigy
    2 years ago

    it's accumulated each other , which is not right 

     

     

    • Daniel29195's avatar
      Daniel29195
      Icon for Community Champion rankCommunity 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,