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 :)

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
⏱️ 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 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* 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

[vishaljhaveri]

One of the best explanation about OFFSET. Thank You.

[ozansen_ozibaba]

This is by far the best explanation about offset! It reminds us of window functions in SQL (LAG and LEAD) as somebody wrote it! I also liked your workarounds!

[andysuzhou]

It reminds me of the infamous EARLIER function, when we try to get the previous row in a dataset; an impossible task in direct query mode. Now it's possible, even it's not the most performant solution. Power Bi is getting better!

[storybi]

I love how you explain things by showing the Excel equivalent, then showing how the function works in Power BI. I tried the OFFSET function and it worked great! Seems like an alternative to the prior pattern, FILTER(ALL(Time.

[luisguardia]

You are saving my project legend, thanks a mill

[omariscoming]

this is huge, so many workaround needed before to this simple thing

[tibobago]

Thanks Bas. Love the examples. I would just call out that while adding the total sales by manufacturer work in your example, it's not dynamic anymore and if a filter was to change the rank of the manufaturers in that filter context, it won't take that context in consideration in the result as it's pulling from the column value. So by example if a manufature ranks 2nd overall, as filters get applied, it could change to 3rd rank but would still be considered as 2nd in your measure... would love to find another workaround that would keep it fully dynamic! I think there's great potential to have fun with that new function, maybe squeezing some field parameters, calculation groups and a slicer to select the offset value on top 🙂

[narendrababu]

As your name reminds me of a bus that makes to touch each stop while travelling. Your videos also touches every problem in that solution. That's a great thing in your videos.

[MJ-guuu]

Thank you very much. I really appreciate the way you teaching, and the level of dedication you make your videos with

[aqavi]

Good work Bas, appreciate your in-depth efforts. I like how you played around with workarounds and explored all tricks to make this work in preview.
Demonstrating what does not work, to understand its best use case, is also very important.

[casingena]

Thanks Bas, it's always good to also show what doesn't work and why, so from me thanks for including these bits rather than leaving them on the cutting room floor :)

[dutchdatadude]

Oh and one mote: - 1 actually moves up one. Not down as you said in your first Power BI demo. Negative is above, positive is below

[hlee]

Lovely lecture! I found your channel is the most helpful! TYTY

[nancylalicon]

Thanks so much for the clear explanation on how to use OFFSET.... I think you just changed my life!

[roverre]

Dear Buz, I am very fascinated by the way you manage to explain in such a simple and clear way, thousands of pages of Microsoft instructions .... !!! 😄 congratulations...!!

It would also be very interesting if you could dedicate some video tutorials about the "Power BI report builder" application to make structured reports that can be printed...Can you do It for us?
Many thanks and 👏👍

[sarveshdeshpande]

Wow …. Understanding dax before release. Great Vedio Bas and use case was also great. Kudos to your hard work 😊 I eagerly wait for your vedios

[tjitzeweisma]

Thanks for sharing. It will work nicely for company specific period codes, as we now easily can calculate the deviation to the previous period.

[vijayarjunwadkar]

Interesting function to know! Thank you Bas for covering in detail, but will require a bit more time and efforts to understand and use it better. Of course, as it is yet to be released, we might see the functionality that you wished for and demonstrated with work arounds actually appear, fingers crossed!

[dutchdatadude]

Thanks for sharing please stay tuned for the official release and much more. We are just getting started!

[ernests]

Thank you for this video, this function is so helpful (to be honest in Tableau different to the next value is super easy, but in PBI it was more challenging), now delta to the next is also easy in PBI, 5!