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 

    • Fowmy's avatar
      Fowmy
      Super User
      2 years ago

      Chanleakna123 

      This is what exactly the formula that I shared does, 
      Sharing a dummy Power BI file representing your scenario would be beneficial. You can save the Power BI file on Google Drive or any other cloud storage platform and provide the link here. Kindly ensure that permission is granted to open the file.




      • Chanleakna123's avatar
        Chanleakna123
        Post Prodigy
        2 years ago

        you can check on the MOM forlmula , seems like not as needed. 
        i would like to have the same period in Last year to be shown next to it.