NEW OFFSET Function in DAX | Will It Change How You Write DAX?

Introducing Power BI's BRAND NEW function: OFFSET in DAX. While it officially not released just yet (september 2022), you can already use it! OFFSET enables you to do visual level calculations by pointing to other cells / datapoints in your visual (kinda like in Excel) - something that was not possible before. In this video I explore how to use the OFFSET function and whether it will change how you write your DAX measures. Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :) Download file here https://datatraining.io/powerbi-how-to -------------------------------- 📊 TRAININGS 📊 --------------------------------- Power BI Design 4 Weeks Transformation Program https://my.datatraining.io/pages/powerbidesigntransformation Power BI Essentials https://datatraining.io/powerbilearningpath Business User Training https://datatraining.io/powerbi-business-users For Custom Trainings and Consulting email directly [email protected] --------------------------------- ⏱️ TIMESTAMPS ⏱️ --------------------------------- 00:00 Intro 00:43 OFFSET example in Excel 03:05 OFFSET example in Power BI 07:05 OFFSET with multiple fields 08:22 OFFSET for time intelligence 12:02 Implementing a meaningful sorting order 18:20 End --------------------------------- 😍 JOIN 😍 ---------------------------------- Join https://bit.ly/4b453bi Subscribe https://bit.ly/31MnQGO​ Insta https://www.instagram.com/howtopowerbi/ LinkedIn https://www.linkedin.com/in/basdohmen/ TikTok https://www.tiktok.com/@how.to.power.bi X https://twitter.com/HowToPowerBI fb https://www.facebook.com/groups/howtopowerbi Threads https://www.threads.net/@howtopowerbi Newsletter https://datatraining.io/newsletter --------------------------------- 👇 CHECK THIS OUT! 👇 --------------------------------- 💻 My gear https://amzn.to/47F21Yc 📚 Power BI books MUST READ! https://amzn.to/3tUfFcj 💡 General books I recommend https://amzn.to/48YNo33 🎶 Music for my videos https://www.epidemicsound.com/referral/8pjcbj 🚀 For growing on YouTube: https://www.tubebuddy.com/bas 🏄 Stuff I use daily https://amzn.to/3HqfMQ2 * Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos! Thanks for being a part of this channel and all your support! 💪 🙏 #HowToPowerBI​ #PowerBI​ #DataTraining​ #powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX