Last month Vs Current Month DAX query

[SachinFG]

Hi All,

I am trying to compare this month till date purchase amount with last month ( same no of days) in Power BI. 

The below are the queries for MTD and LMTD :

MTD:

 PurchaseAmount_MTD = Calculate(SUM(Schedule[ESC_PURCHASE_AMOUNT]),DATESMTD('Date'[Date]))

LMTD:

PurchaseAmount_LastMonth = Calculate( sum(Schedule[ESC_PURCHASE_AMOUNT]),DATEADD('Date'[Date],-1,MONTH))

& 

PurchaseAmount_LMTD = Calculate([PurchaseAmount_LastMonth],DATESMTD('Date'[Date]))

The below is the output of the 2 queries (which is wrong).

Can anybody please help me?

 

[amitchandak]

@SachinFG , This output seems correct.