Variables in power query | How and practical use case

Рет қаралды 13,230

2 жыл бұрын

In this video I will show you filter your table by the last available record using variables in Power Query.
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
************
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:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE

Пікірлер: 23

@TheKukusa 2 жыл бұрын

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!

@kasbu 2 жыл бұрын

I had a similar question - while its fun to learn more code, why not go through UI as under "Date" filters you have many options like "Is Latest" or "Is Not Earliest" and many more? I often connect to organized SP folders and use these filter options to select relevant file to pull based on file creation date meta data. I can also sort and add index to allow me to filter for the last "n" files for getting a rolling trendline.

@Milhouse77BS 2 жыл бұрын

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

@CurbalEN Жыл бұрын

Super thanks!! Coffee on its way :)

@gouthamkarakavalasa4267 2 жыл бұрын

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

@gurujeetkhalsa1362 2 жыл бұрын

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

@CurbalEN Жыл бұрын

Perfect timing !!

@EricaDyson 2 жыл бұрын

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

@CurbalEN Жыл бұрын

😂 thanks Erica!!

@ewad 2 жыл бұрын

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

@loryber Жыл бұрын

Thank you Ruth, short and very valuable!

@CurbalEN Жыл бұрын

Music to my ears!!

@JohnKpl 2 жыл бұрын

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

@CurbalEN Жыл бұрын

Thanks!

@VladMZ 2 жыл бұрын

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.

@CurbalEN Жыл бұрын

I give you guys options, that is all :)

@davsac6175 5 ай бұрын

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.