Forum Discussion

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 is 4th Aug21

Hence Last 5 months MTD would be

MTD Aug21= 1-4th Aug

MTD July21 = 1-4th July

MTD Jun21=1-4th June

MTD May21=1-4th May

MTD Apr=1-4th Apr

and it will based on today date.

Please help me on this please.

Thanks

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
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

7 Replies

Tanushree_Kapse
Impactful Individual
5 years ago
Hi Anonymous ,

Try:
Measure=
CALCULATE(TOTALMTD(SUM(Total Sales),Table[Date]), PARALLELPERIOD(Table[Date], -4, MONTH))

I hope this helps!
Thanks.
- Anonymous
  Not applicable
  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
  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
    Impactful 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!