Data Cleaning Exercises

Pro exercise

Map months to fiscal quarters

The company's fiscal year starts in April, so March 2026 belongs to FY25 Q4, not to calendar Q1. Map each month with the finance calendar table instead of computing quarters, then total revenue per fiscal quarter.

  • calendars
  • lookups
  • aggregation

Sign in with a Pro or Lifetime plan to open the rules, the dataset and the workspace.