New sold to item flag

[EV]

Hi i need help with creating a flag to show the item number first time appeared on an invoice for the last 2 years from current period?
Also need help to create a new win flag for the rolling 12 months? I have the new win flag determined from other condition, but the end i want help in creating this flag for rolling 12 months from the current period or the selected period?

can you please help?

[v-frfei-msft]

Hi @EV ,

Could you please share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.

Regards,

Frank

[EV]

Sure Thank you for your response, I will gather sample data and expected result and share it here