5 tips to work faster and do some cool things in Power Query

Рет қаралды 9,019

Күн бұрын

In todays video, I am going to give you 5 tips to work faster in power query and to do some cool stuff too. Are you ready?
Chris webb blog:blog.crossjoin.co.uk/2020/07/...
Chapters:
00:00 Intro
00:17 Add a tooltip to a power query column
00:57 Call out Power query intellisense
01:40 Quickly rename a step
02:06 Zoom in and out the power query editor
02:40 Apply or discard changes in Power Query
Done!
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
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
curbal.com/product/sponsor-me
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE

Пікірлер: 44

@nickdoy7019 3 жыл бұрын

F2 to rename will save me so much time and for anyone not already doing it always rename your steps and add descriptions in the advanced editor where neccessary. I blindly took this advice on board when I started and it has bailed me out of trouble so many times when returning to projects after a break. Keep up the good work Ruth!

@CurbalEN 3 жыл бұрын

That is great advice !! :)

@alfredsfutterkiste7534 3 жыл бұрын

Absolutely. Be good to your future self! Document your M!

@CurbalEN 3 жыл бұрын

😂

@sandymaverick4702 3 жыл бұрын

Watching this so that wonderful series on Power Query continues. GO Ruth, more Power to you :)

@CurbalEN 3 жыл бұрын

I wont stop making power query videos, just do less of them ;)

@brunof.s.8186 3 жыл бұрын

Ruth, your power query tips are a life saving. just yesterday i've put in pratice that one in "Conditionally replace values in Power Query in one step", and it was pretty awesome. M language is such a hard language but when you combine with the UI it gets much easier. Happy (almost) 50k subscribers! Cheers

@CurbalEN 3 жыл бұрын

I love that trick too, such clean way to do it!! And thanks ;)

@cristianprifti 3 жыл бұрын

@@CurbalEN see, i am not the only one who loves your M videos 😃

@CurbalEN 3 жыл бұрын

Hey, I love my M videos too!! 😂😂

@ssma1368 3 жыл бұрын

Hi dear Ruth, the last tip was wonderful and so the best one. Thanks a million for your useful tutorials!!!

@CurbalEN 3 жыл бұрын

Hi again and my pleasure !!

@Phoenixspin 3 жыл бұрын

People and Aliens in the Universe, please watch Ruth's Power Query videos so she will feel encouraged by the view count. We too can master Power Query if we stick with Ruth. We appreciate the knowledge she is sharing.

@CurbalEN 3 жыл бұрын

Still doing poorly 😪

@paspuggie48 3 жыл бұрын

Never knew the zoom. Brilliant 😉😊

@17avskadoo 3 жыл бұрын

Thanks a lot for this wonderful video

@CurbalEN 3 жыл бұрын

You are most welcome!

@obedplascenciasoto 3 жыл бұрын

Gracias Ruth, excelentes tips

@CurbalEN 3 жыл бұрын

Un placer!

@untype 3 жыл бұрын

Awesome tips! tack.

@CurbalEN 3 жыл бұрын

Varsågod!

@HachiAdachi 3 жыл бұрын

YES! 😀 PQ video is BACK! 🎉 On Wednesday!! 😮 ... Shall we call it, um, "Power Query-nesday"? ...Not as catchy as (M)agic (M)onday, I'm afraid... But the important thing is PQ got some love! Thank you, Ruth!

@CurbalEN 3 жыл бұрын

It was never gone, and it is not truly back ...does it makes sense? 😂😂

@dannyhometown 3 жыл бұрын

Thanks Ruth, Ctrl Shift +/-. This one is saving my eyes. Without this, I might be blind after few years PBI dashboard development. :P

@CurbalEN 3 жыл бұрын

I was already blind so I wont be able to blame power bi 😂😂😂

@dannyhometown 3 жыл бұрын

@@CurbalEN Hahaha.... Please take care.

@CurbalEN 3 жыл бұрын

Bad genes...nothing to do about it 🤷‍♀️

@AJM2183 3 жыл бұрын

Thanks!

@CurbalEN 3 жыл бұрын

You bet!

@noahhadro8213 3 жыл бұрын

such good information

@CurbalEN 3 жыл бұрын

Thanks Noah :)

@jimfitch 3 жыл бұрын

Ctrl Shift +/- !!! Great discovery. I have monitors with different resolution than my laptop, & it drives me insane when switching the PQ Editor between screens, but it does not resize (way too large). I’m going to try Ctrl Shift +/- tomorrow to see if it solves the problem. Thanks, Ruth!

@CurbalEN 3 жыл бұрын

Fingers crossed!! 🤞🤞

@jimfitch 3 жыл бұрын

It works! Thanks again, Ruth

@CurbalEN 3 жыл бұрын

Yey!! 🥳🥳

@17avskadoo 3 жыл бұрын

Ctrl shift + / - is my fav tip

@CurbalEN 3 жыл бұрын

I too have bad eyes ;)

@totvabe1 3 жыл бұрын

@@CurbalEN Curious that in the DAX bar you zoom in with Ctrl + + (or Ctrl + Mouse Scroll Up) and you zoom out with Ctrl + - (Ctrl + Mouse Scroll Down). Different way !!!

@CurbalEN 3 жыл бұрын

Different products, different developer teams 🤷‍♀️

@kishoreo8623 3 жыл бұрын

Ctrl +shift +/- is best...I have bad eyes... Is there any possible way if I delete a measure and need it back again

@CurbalEN 3 жыл бұрын

No, backup copies is the only way...

@nickdoy7019 3 жыл бұрын

Edit your measures in Tabular editor as it will allow you to undo for measures. Undo in Power BI desktop only restores visual related actions and not the model.