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

No video

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

Рет қаралды 5,813

Күн бұрын

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/b....
👍 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...
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2u...
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks...
🔗Pragmatic Works Boot Camps: pragmaticworks...
🔗Pragmatic Works Hackathons: pragmaticworks...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks...
🔗Pragmatic Works Blog: blog.pragmaticw...
Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️KZfaq: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
#PragmaticWorks

Пікірлер: 10

@randomname8803 3 ай бұрын

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

@KiFiPL 6 ай бұрын

Thank you! Really appriciate good explanation

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

@user-et3fc4vj4f 9 ай бұрын

Thank you!! It really the found of the day

@PragmaticWorks 8 ай бұрын

Glad it helped! Thank you for learning with us.

@abubakrsaadmakyhoun7535 11 ай бұрын

you are the best

@khulekanimzobe4825 6 ай бұрын

Thanks man 😎

@v2blaster228 9 ай бұрын

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