Variables in power query | How and practical use case

In this video I will show you filter your table by the last available record using variables in Power Query.

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

************

MY GEAR: You often ask me what software I use to edit my videos, so I thought I let you know in the description and give you a discount code so you can get it too!
COUPON: CURBAL10

Note, if you purchase the software using the link or code, I will receive a small commission and you will indirectly support my channel. Thanks in advance!

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#CURBAL #SUBSCRIBE

[TheKukusa]

Did you know UI can do this for you? on Date column - filter > Date/Time filters > Is Latest
I always use this way to remind myself of the syntax!

[MilhouseBS]

Thanks for all the tips over years. You deserve a coffee.

[gouthamkarakavalasa]

Hi Ruth, regarding MS offering, I always jump into to ur channel if I got stuck anywhere... You made my life easy.. thank you very much for the content :)

[EricaDyson]

How did you know I was wanting to do this 3 days ago! You're a mind reader! Mega thanks.

[gurujeetkhalsa]

Super useful and timely - I was just trying to figure out how to do something like this. Thanks!

[davsac]

Thank you for this video! I'm desperate about a very simple task that I can't get: how to increment a numeric variable? Kind of this: var = 2, var = var+1. In all other languages it works, but in Powerquery it doesn't. Looks like you can't reference last value of a variable to increment it by a constant.

[loryber]

Thank you Ruth, short and very valuable!

[ewad]

Really useful Ruth :) Thank you for another good tip.

[VladMZ]

No to rain on your parade, Ruth, although your application of this trick is interesting. It's well described in articles about how to do non-equi join in Power Query. You know, when you have a table of ranges and your join condition is fact date between start date and end date of the range. This way one would get range's ID and put it into the fact table, instead of coding ranges in DAX. I know it's a bit advanced star schema sorcery, but useful nonetheless.

[JohnKpl]

This is great tip, and easy to use. Thank you :)

[bravucod]

I'm having a hard time finding the download file

[shivasai]

Where can i get more DAX scenarios like 25 days of DAX challenges
I would love to practice more n more.
Any suggestions