So I have dataset of orderdata that have manipulated a bit. I have defined customers depending of if they are new or existing.
New = First order
Existing = not first order
However, I would like to break up orders from Existing customers into Active / Reactivated.
Active = Order is within 12months of last/latest order
Reactived = Order is more than 12 months since last/latest order
Basically, in the Power Query I would like to be able to say "if order is within 12months of last order then 'Active' "
Can't figure out how to do it! Dataset looks like this: