1 of 1 people found this helpful
Eugene if I'm understanding your question correctly, this should work:
dateadd ('week', -12, DATETRUNC('week', [sales_data]))
Thank you Shawn! It works for TY period!
Could you also provide me with the information how can I do the same for LY period (as applied to my example above)?
Eugene, please post another workbook with the TY working and the LY not working, and I'll take a look. Thanks,