Perform a lag and lead operation in DAX with OFFSET window function

In this video Mitchell walks through and discusses the OFFSET function in DAX. This single function provides the capability of LAG and LEAD from T-SQL Window functions. This is an in-depth review of the various parameters and how to perform a lag and lead operation in DAX!
Blog mentioned in video:
powerdobs.nl/blog/new-in-dax-....
👍 If you enjoy this video and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Mitchell30" at check out when purchasing our On-Demand Learning classes to get an extra 30% off - pragmaticworks.com/pricing/
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2ujujsb5
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/
Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️RUclips: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
Email: [e-mail]
#PragmaticWorks

[@randomname8803]

Thanks a lot! Your explanation is the best! Spend several hours trying to find sql window functions alternative in dax, until found this video. It hits perfectly

[@VisioNOIR.]

Exactly what I needed right now. Thank you very much!
My use case is a little bit more complicated, but this window function should do the trick, I hope...

[@KiFiPL]

Thank you! Really appriciate good explanation

[@user-et3fc4vj4f]

Thank you!! It really the found of the day

[@PragmaticWorks]

Glad it helped! Thank you for learning with us.

[@khulekanimzobe4825]

Thanks man 😎

[@abubakrsaadmakyhoun7535]

you are the best

[@v2blaster228]

This is super helpful, much appreciated. How do you make this dynamic such that you can choose the lead/lag value with a slicer and have the lag applied? I tried creating a Measure but I couldn't get the correct values for the life of me

[@VictorFloresChovis]

really thank you, as you said there is not much helpful information outside

[@lionels839]

Where is the WINDOW function?