I want Last Months value by LAX function n in power bi

[arvindyadav]

Hi Team,

I want previous month value where my current month is January 2019 and the previous month is December 2018.

I am using DAX formula like 

Last month = TOTALMTD([Profit'],DATEADD(DimDate[Date],-1,MONTH))

But won't getting anything from data. Please explain to me why it is happening and if there is a formula to create Last month value, please provide me,

Thanks,

Arvind

[themistoklis]

@arvindyadav

Try the following formula:

Last month =
CALCULATE ( [Profit'], DATEADD ( DATESMTD ( DimDate[Date] ), -1, MONTH ) )

[arvindyadav]

Hi @themistoklis,

Still getting blank value.

Thanks,

Arvind

[themistoklis]

@arvindyadav

Can you share the workbook with us?

[arvindyadav]

Hi @themistoklis,

Nope, Actually, it is confidential.

But I can share with you some screenshots to understand the data.

[themistoklis · Accepted solution]

@arvindyadav

Have a look at the attached file.

I have created 2 measures. One that gets the values from previous month and the other which gets the cumulative sum.

[arvindyadav]

Hi @themistoklis,

It works.

Thank You!!