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 жыл бұрын

😂

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

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 !!

Never knew the zoom. Brilliant 😉😊

Gracias Ruth, excelentes tips

@CurbalEN

3 жыл бұрын

Un placer!

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 😪

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? 😂😂

Thanks a lot for this wonderful video

@CurbalEN

3 жыл бұрын

You are most welcome!

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!! 😂😂

Awesome tips! tack.

@CurbalEN

3 жыл бұрын

Varsågod!

Thanks!

@CurbalEN

3 жыл бұрын

You bet!

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 🤷‍♀️

such good information

@CurbalEN

3 жыл бұрын

Thanks Noah :)

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 🤷‍♀️

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!! 🥳🥳

I wonder if there available in excel power query?

@CurbalEN

3 жыл бұрын

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

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.