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. 

      • Fowmy's avatar
        Fowmy
        Super User
        2 years ago

        Chanleakna123 

        Without looking at your data model, the exisitng measures and how you are trying to implmenet this measure, it's hard to suggest a solution. Create a small Power BI file representing you scenario and share it using google drive or any other sharing option.