Values of previous month

[nike31]

Hello,

I have following table. In the first column there is the product group (there are several). In the second column there is the date and in the third row there is the value of the order backlog.

How can I create a forth column that shows the value of the previous month. E.g. in row 2 the previous month value would be from the 31st January and is 1178,86865

Thank you! 😃

[Anonymous]

Hi @nike31,

You can also try to use below formula to get last day amount of previous month.

Previous = LOOKUPVALUE([Amount],Sheet1[PG],[PG],Sheet1[Daturm],DATE([Daturm].[Year],[Daturm].[MonthNo],1)-1)+0

Regards,

Xiaoxin Sheng

[Bhavya_v]

I was facing a similar issue, and the accepted solution did not work for me for some reason. This one worked though, thanks!

[Anonymous · Accepted solution]

@nike31

I assume you'd like it to be based on the product group?

Then try this calculation:

= CALCULATE(SUM(Table[Auftragsbestand]); VALUES(Table[PG]);DATEADD(Table[Datum];-1;MONTH))

Let me know how it goes.

Best,

Martin

[Kasonga2018]

Hey, Please advise, what if I want to base this on two columns

[nike31]

Thank you! This works perfectly!