I am trying to bring in only Year data (no month or Quarter) but I do not seem to have only Years when I choose the Time.
I am trying to get data for FY16, FY17, FY18, and then trying to do average of FY16 and FY17, and FY17 and FY18.
I tried hiding the months, however, when I use the Period or Lead or Lag, it looks at the month.
In the Blueprint mode of your module, choose Year as Time Scale (See attached screenshot),that will give you only Year and you can also use Lead/Lag functions.
You can also use Movingsum to have a rolling two year average
See below for more details