avearge order value same

AI Training: For Busy Decision Makers & Professionals Book now

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

resolvedResolved · Medium Priority · Version 2016

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.

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

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Power BI tip:

Stay Updated and Engage with the Community

Power 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.

View all Power BI hints and tips


Server loaded in 0.14 secs.