topic Re: Last month calculation got wrong result when show by daily in DAX Commands and Tips

Last month calculation got wrong result when show by daily

Anonymous — Fri, 13 Jan 2023 10:32:50 GMT

Dear Team,

I would like to seek support from team, I am facing calculation of last month and got imporper result when show by dialy.

calculate MtdAct: CALCULATE(sum(SaleInvMovement[SaleAmt_Amt]),DATESMTD('Date'[Date]))

calulate LM_MtdAct: CALCULATE(MeasureTable[MtdAct],DATEADD('Date'[Date],-1,MONTH))

I am apreciated for help. Thanks

LC Aynar

Re: Last month calculation got wrong result when show by daily

JFAR49ER — Fri, 13 Jan 2023 10:49:52 GMT

Hi,

Could you possibly use measure branching for this?
I.e Calc Last Month MTDAct = CALCULATE([MtdAct], PREVIOUSMONTH('Date'[Date]))

PREVIOUSMONTH : Returns a table that contains a column of all dates from the previous month, based on the first date in the Dates column, in the current context.
https://learn.microsoft.com/en-us/dax/previousmonth-function-dax
So your measure for this month is called in and then the filter is MTD but previous month.

Let me know if this works? Hope its helpful 🙂

Re: Last month calculation got wrong result when show by daily

Anonymous — Sat, 14 Jan 2023 01:10:59 GMT

Hi JFAR49ER ,

Thanks your for your prompt help, however, the result is still improper figure stated below:

LM_MTDAct_new = CALCULATE(MeasureTable[MtdAct] ,PREVIOUSMONTH('Date'[Date]))

I am appreciated for any solution. Thanks!

LCAynar