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
Fowmy's avatar
Fowmy
Super User
2 years ago

Chanleakna123 

Follow the same pattern as per this formula:

MoM = 

VAR __CM = [Sales Amount]
VAR __Period = DATEADD( DATESBETWEEN( 'Date'[Date] , MIN( 'Date'[Date] ) , MAX( 'Sales'[Order Date] ) ) , -1 , YEAR )
VAR __LYSM = CALCULATE( [Sales Amount] ,__Period )
RETURN
  __CM -  __LYSM



 

Chanleakna123's avatar
Chanleakna123
Post Prodigy
2 years ago

Not reflect to what i need , 

when i do this calculate , it show my MTD is in Negative . 
i may need MTD this year vs. MTD last year , with the same period day