The DAX OFFSET Function in Power BI | Comparisons with SQL LAG & LEAD Window Functions
In this short tutorial, I'll give a short overview of the new OFFSET function in DAX, which is not yet released or documented- but it's available to use and very flexible.
With comparisons to the LAG & LEAD Window functions in SQL, it makes exploratory and quick data analysis very easy to follow.
Enjoy!
🤝 Connect with me on LinkedIn:
/ ja376
🤝 View my Website:
https://www.matadorsoftware.me
🖥📝 I also have a great value 2 hour data career consultation service to get you on the right track. Covering resumes, ATS, data technology, soft skills, roadmaps and a take home document pack at great value. Check out the Fiverr gig below:
https://www.fiverr.com/share/z3x07g
