Before this formula it can be very difficult to compare previous years data with the current data to measure a business performance. In this video I explained how to create formulars using one of the Time Intelligence Function - SAMEPERIODLASTYEAR.
Link to file: https://docs.google.com/spreadsheets/...