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
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,