Avearge order value same period LY

Hi Nicola,

Thank you for the forum question.

You can use the SamePeriodLastYear function.

"Field Name"=Calculate("Your Average Order Value measure",SamePeriodLastYear("Your primary key field from your date table"))



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector