Working with SAMEPERIODLASTYEAR and DATEADD in DAX and Power BI Desktop

In this video we dive into DAX and the functions SAMEPERIODLASTYEAR and DATEADD. In Power BI Desktop we visually show the results of each function and how SAMEPERIODLASTYEAR is derived from DATEADD. This video also highlights how Calculation groups can be used to reduce the number of measures in your data model. Download Tabular Editor: https://github.com/otykier/TabularEditor/releases/download/2.12.4/TabularEditor.Installer.msi If you enjoy this video and are interested in formal training on DAX, Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Mitchell20" to receive a discount at check out when purchasing On-Demand Learning classes from https://pragmaticworks.com/pricing/ #PragmaticWorks #MitchellPearson #MitchellSQL - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - Next step on your journey: 👉 On-Demand Learning Courses FREE Trial: https://www.pragmaticworkstraining.com/on-demand-learning-free-trial/ 🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/ 🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/ 🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-training/hackathons/ 🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-mentoring/ 🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-training/customized-enterprise-training/ 🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/ Let's connect: ✔️Twitter: https://twitter.com/PragmaticWorks ✔️Facebook: https://www.facebook.com/pragmaticworks/ ✔️Instagram: https://www.instagram.com/pragmatic.works ✔️LinkedIn: https://www.linkedin.com/company/pragmaticworks ✔️YouTube: https://www.youtube.com/pragmaticworks Pragmatic Works 7175 Hwy 17, Suite 2 Fleming Island, FL 32003 Phone: (904) 413-1911 Email: [email protected]