How to calculate YoY change using self-join

[dgudkov]

Here is another variation that also uses a self-join:

1. Calculate next year dates by using addyears().
2. Merge (self-join) sales amount where current date matches next year date - it will bring into one row last year sales and current year sales.

yoy-selfjoin.morph (4.0 KB)