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

[@nickdoy7019]

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]

That is great advice !! :)

[@alfredsfutterkiste7534]

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

[@CurbalEN]

😂

[@Phoenixspin]

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]

Still doing poorly 😪

[@ssma1368]

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

[@CurbalEN]

Hi again and my pleasure !!

[@sandymaverick4702]

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

[@CurbalEN]

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

[@HachiAdachi]

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]

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

[@paspuggie48]

Never knew the zoom. Brilliant 😉😊

[@obedplascenciasoto]

Gracias Ruth, excelentes tips

[@CurbalEN]

Un placer!

[@brunof.s.8186]

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]

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

[@cristianprifti]

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

[@CurbalEN]

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

[@17avskadoo]

Thanks a lot for this wonderful video

[@CurbalEN]

You are most welcome!

[@dannyhometown]

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

[@CurbalEN]

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

[@dannyhometown]

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

[@CurbalEN]

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

[@noahhadro8213]

such good information

[@CurbalEN]

Thanks Noah :)

[@untype]

Awesome tips! tack.

[@CurbalEN]

Varsågod!

[@jimfitch]

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]

Fingers crossed!! 🤞🤞

[@jimfitch]

It works! Thanks again, Ruth

[@CurbalEN]

Yey!! 🥳🥳

[@17avskadoo]

Ctrl shift + / - is my fav tip

[@CurbalEN]

I too have bad eyes ;)

[@totvabe1]

@@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]

Different products, different developer teams 🤷‍♀️

[@AJM2183]

Thanks!

[@CurbalEN]

You bet!

[@johnhartley2438]

I wonder if there available in excel power query?

[@CurbalEN]

Don't know, haven't tried in excel :)

[@kishoreo8623]

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

[@CurbalEN]

No, backup copies is the only way...

[@nickdoy7019]

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.