98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Power BI training and help » Avearge order value same period LY
Avearge order value same period LY
Resolved · Medium Priority · Version 2016
Wed 10 Jun 2020, 15:49Delegate Nicola said...
Nicola has attended:
Power BI Reporting course
Avearge order value same period LY
I have calculated the average order value for TY and want to see the average order value for LY in the same period to see the variance.
Thu 11 Jun 2020, 14:58Trainer Jens said...
RE: 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
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Power BI tip:Stay Updated and Engage with the CommunityPower BI is continually evolving, with new features and updates being released regularly. Stay informed about the latest enhancements by regularly checking the Power BI blog and community forums. Engaging with the Power BI community provides opportunities to learn from others, share your experiences, and get insights into best practices. |
