Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Calculating Same Period Last Month !!!

Hi Geniuses,    I have created a measure to calculate MTD sales of my product category now I want to calculate sales of same premiod last month to compare. My Dax formula is returning the same resu...
datesbetween
Time Intelligence
selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

Hey Anonymous ,

 

is that still ongoing or could you solve the issue?

If it's still unsolved you have to upload the file again as it expired.

 

Best regards

Denis

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    4 years ago

    Hey Anonymous ,

     

    I downloaded the file and don't see anything you showed on the first post in the file.

    Can you explain again what you are trying to do, what is the result and what you expect as a result?

     

    Maybe prepare the file, that I only have to open it and see your case.

     

    Best regards

    Denis

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi selimovd,

       

      Sorry I might have renamed those measures which makes them difficult for you to understand !

      Below measure #1 is what returns the sales quantity in current month and measure #2 is what I expect to return sales quantity of same period last month and change in percentage. 

       

      Measure #1
      MTD PREMIUM Sales Installed =       CALCULATE([PREMIUM Sales],
      DATESBETWEEN('Sales Report'[Installation Date],
      DATE(YEAR(TODAY()),MONTH(TODAY()),01),TODAY()
      )
      )

       

      Measure #2
      MTD PREMIUM Sales SPLM =
      VAR SPLM = CALCULATE([MTD PREMIUM Sales Installed],PARALLELPERIOD('Calendar'[Date],-1,MONTH))
      RETURN
      DIVIDE([MTD PREMIUM Sales Installed]-SPLM,SPLM)
       

      TIA