Previous Year to Date Calculation


Hi everyone,


I am in need of a formula for specific line items from our P&L that calculates the previous year's YTD values. 


For example our YTD currently shows Jan 22 - May 22. 

Ideally I could have a separate model to choose each line item and show the YTD for Jan 21 - May 21.

Is this possible?

Best Answer

  • CamdenMaggos
    Answer ✓

    I solved this just by using a separate model with the offset function and referencing each desired line item from the desired model, in combination with the YTD column.