MTD CALCULATIONS FOR LAST 5 MONTHS

[Anonymous]

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 · Accepted solution]

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

[Tanushree_Kapse]

Hi @Anonymous ,

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

I hope this helps!

Thanks.

[Anonymous]

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]

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]

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

[Anonymous]

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

[Anonymous · Accepted solution]

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 · Accepted solution]

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