Creating A new Column with the previous month value from the different column for all rows

Question

I have Data like below, Date is is (MM/DD/YYY-Format)

DateSalesItemProfit05/01/2022100Monitor20005/01/2022200Mouse30006/01/2022300Monitor40006/01/2022400Mouse 400

I want the output as below,

DateSalesSales Previous MonthItemProfitProfit Previous Month05/01/2022100April month valueMonitor200April month value05/01/2022200April month valueMouse300April month value06/01/2022300100Monitor40020006/01/2022400200Mouse 400300

Hi Community, Please Help me in achieving this.

Thank you.

kiotsuresh · Answer

Hey yeah tried your solution didn't worked out, Actually I can't share the workflow due to data reasons.

Christina_H · Answer

Here's an alternative version using a join rather than multi-row formula, applied to both data sets.

Prev month values.yxmd

Luke_C · Answer

Hi @kiotsuresh

Have you tried the solution I posted? I believe it should work (or be easily adaptable) in your workflow. Can you share your workflow and I can help you troubleshoot? That will help you best learn.