Not able to get previous year data correctly with reference to current year

I want previous year sales data,
Need to match the current date with previous year date and get sales data for the previous date.
I have tried using join and union tools,
initially joining the previous year transaction date with current year transactiondate and trying to get the prev year net sales, but values are not accurate.

i am getting null for previous year sales

Current Year Date	Previous Year Date	Current Year Sales	Previous Year Sales
21-12-2021	20-12-2020	166668888	Null

Developer

Accepted answers

All comments

atcodedog05

Hi @somuayoddhya

Can you provide some sample input (which has both current year and previous year data) and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

Qiu

@somuayoddhya
If I understand you correctly.

Since you want the date to be matched, so lets remove the year.

New Workflow6.yxmd

AbhilashR

Hi @somuayoddhya, assuming your data is structured in a manner where current and prev year values are part of the same column attribute, you can create a new date column and subtract one year from each date, and join it back to itself to get current and prev yr values. Attached is a proof of concept of what that might look like

Hope this helps!

sample.yxmd

atcodedog05

Hi @somuayoddhya

My approach is similar to @AbhilashR I am using find and replace tool instead of join tool to include row entries even if they don't have the previous year.