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/powerbihowto
TRAININGS
Power BI Design 4 Weeks Transformation Program https://my.datatraining.io/pages/powe...
Power BI Essentials https://datatraining.io/powerbilearni...
Business User Training https://datatraining.io/powerbibusin...
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 / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / 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/referra...
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