Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

MTD CALCULATIONS FOR LAST 5 MONTHS

Hello Guys,   Hope you are well, I have one problem, I have to calculate MTD for last 5 months like right now we have in Aug21 so last 5 months would be Aug21,July21,Jun21,May21,Apr21  and today...
MTD
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi,

    I am trying this but out is showing blank

    Pre_Month-2 = CALCULATE(TOTALMTD([Sec_Vol],'db_CSA_Data Yield_Sec_Test'[InvoiceDate],PARALLELPERIOD('db_CSA_Data Yield_Sec_Test'[InvoiceDate],-3,MONTH)))
     
    [Sec_vol]- it is already in sum
     
    Please help me on this
  • Anonymous's avatar
    Anonymous
    5 years ago

    Got it by my own logic,

     

    prev month MTD Vol = CALCULATE(SUM('VIT-IK SAP_Secondary_data'[Volume]),FILTER('VIT-IK SAP_Secondary_data',DAY('VIT-IK SAP_Secondary_data'[InvoiceDate])>=1 && DAY('VIT-IK SAP_Secondary_data'[InvoiceDate])<=DAY(MAX('VIT-IK SAP_Secondary_data'[InvoiceDate]))),FILTER('VIT-IK SAP_Secondary_data',(YEAR('VIT-IK SAP_Secondary_data'[InvoiceDate])=YEAR(MAX('VIT-IK SAP_Secondary_data'[InvoiceDate]))&&MONTH('VIT-IK SAP_Secondary_data'[InvoiceDate])=MONTH(MAX('VIT-IK SAP_Secondary_data'[InvoiceDate]))-1)))
     
    It is giving me 1-4th July 21 vol=758 that is correct
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

Thanks for your great help,

One more help please as MTD for current is showing correct number but while previous month it is showing full month data.

for Example today is 5th aug then MTD is 1-5th aug sales data similarly for previous month mtd it should 1-5th July of total sales 

please help on this thanks.

Tanushree_Kapse's avatar
Tanushree_Kapse
Icon for Impactful Individual rankImpactful Individual
5 years ago

Hi Anonymous 

 

Try this measure:

Prev MTD = CALCULATE([Sec_vol], PREVIOUSMONTH(DATESMTD(db_CSA_Data Yield_Sec_Test'[InvoiceDate])))

 

I hope this helps!

 

If this answers your question, please mark it as a solution.  Kudos are always appreciated.

Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    This dax giving me full month sales instead of 1-5th Jul21.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      output should be 758 for 1-4th July 21.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Got it by my own logic,

         

        prev month MTD Vol = CALCULATE(SUM('VIT-IK SAP_Secondary_data'[Volume]),FILTER('VIT-IK SAP_Secondary_data',DAY('VIT-IK SAP_Secondary_data'[InvoiceDate])>=1 && DAY('VIT-IK SAP_Secondary_data'[InvoiceDate])<=DAY(MAX('VIT-IK SAP_Secondary_data'[InvoiceDate]))),FILTER('VIT-IK SAP_Secondary_data',(YEAR('VIT-IK SAP_Secondary_data'[InvoiceDate])=YEAR(MAX('VIT-IK SAP_Secondary_data'[InvoiceDate]))&&MONTH('VIT-IK SAP_Secondary_data'[InvoiceDate])=MONTH(MAX('VIT-IK SAP_Secondary_data'[InvoiceDate]))-1)))
         
        It is giving me 1-4th July 21 vol=758 that is correct