CRAZY keyboard shortcuts for DAX in Power BI Desktop

[@guilhermefrazato9425]

Patrick, Adam and guy in a cube team, i really want to say thanks for your videos it help us a lot. Im from brazil, i never saw a mug that express what i like than this one in this video. You could send one for me ! 😂😂😂 lol

[@mbquinn]

Gonna have to keep this one to rewatch! So much to learn. So little time.

[@GuyInACube]

Love it! 👊 thanks for watching.

[@OmisileKehindeOlugbenga]

Some of these are MS Word Shortcuts we've been practicing for years and now they come quite handy for DAX. Thanks mehn.

[@jtmh31]

These are some amazing shortcuts! This will make DAX so much easier to write!

[@GuyInACube]

That was the hope! Glad you found it useful. 👊

[@kyleparsons1735]

4:18 This would have saved me so much time when I was first starting out. Now I know!

[@GuyInACube]

and knowing is half the battle 👊

[@Randyminder]

Very nice! With regards to pressing the ALT key and clicking on lines of code to generate vertical lines, to perform some operation, like commenting out those lines, you can move the vertical lines up and down, as a whole, with the up and down arrow keys.

[@GuyInACube]

Very cool! Thank you for sharing 👊

[@GoodlyChandeep]

Would you be surprised, if I told you that most of these would work in M / Power Query Advanced Editor too! Here are a few other DAX shortcuts I complied - www.goodly.co.in/dax-keyboard-shortcuts-powerbi/

[@GuyInACube]

Love it! 👊 I have to say, not completely surprised haha. Appreciate you sharing that.

[@vinamarieguinto1020]

I listed them all on my notepad. Thank you Patrick!

[@mattsnow2376]

Awesome Patrick! So helpful

[@GuyInACube]

Appreciate that. Thanks for watching 👊

[@bilalazim1901]

Awesome Spent a life time learning excel shortcuts Now on to pbi

[@GuyInACube]

Indeed. there are more outside of DAX. But, we have had mixed results with using them. Thanks for watching 👊

[@antoniodamore]

Very helpful video. Thanks !

[@GuyInACube]

Most welcome! Thanks for watching. 👊 Be sure to check some of the other comments. People are offering other tricks as well :)

[@mikar636]

Thank you!!

[@daviddossantos5936]

Thank you!, more efficient now! and PB rules!

[@alessandrofrancisco9149]

You can use Ctrl + KC and Ctrl + KU to coment blocks of code

[@GuyInACube]

Nice! Thanks for mentioning that. Although the CTRL + / is a little easier to use.

[@zulfikarvirani]

Great video Patrick and Team 👍 I just tried a bunch of these and Hot-keys make it fun to work on DAX ♥️ Keep up the good work...

[@GuyInACube]

Love it! Glad to hear it is helping you out. Thanks for watching 👊

[@TTfromOZ]

Wow!!! So useful!!! And so coooooool!

[@mattmiller07]

This is awesome. I'm a hotkey junkie so this was amazing.

[@GuyInACube]

Awesome! There are other keyboard shortcuts outside of DAX as well. Although we have had mix results when using them.

[@DreeKun]

Nice! This kind of tips are awesome. I also found out that the reason why my selected dax code would grey out sometimes, and i couldn't ctrl + c. I have an habit of moving the cursor to outside of the code window when selecting, and that way it doesn't work. I felt dumb. Keep the tips coming!

[@GuyInACube]

Have hit that before as well. If the focus shifted outside of the editor window, it can make for some frustration. You are not alone. 👊

[@fethiachour711]

Thank you. How can i use "Solver" in Power BI like in Excel?

[@crax2000]

Alt Power my friend!!!! Awesome cool tips and tricks on shortcuts!!! This is bananas!!!! Thanks for sharing!

[@GuyInACube]

haha of course it is :) Appreciate it Gaston! See you at Ignite.

[@1yyymmmddd]

Instead of Ctrl-Shift-L you can use Ctrl-F2.

[@GuyInACube]

Oh nice! Thanks for that 👊

[@muzahidali12]

Ctrl + / can be used for comment and uncomment of DAX. What I am waiting is DAX formatter in PBI desktop and shortcuts for creating measures / coulmns.

[@GuyInACube]

Yup. we stumbled on that making the video and called it out :) Wasn't documented though. Would love to have DAXFormatter in PBI Desktop, but I doubt it will come.

[@kim1217]

I ❣️ hotkeys... This is awesome!! Thanks for sharing :-)

[@androo235]

Great but how about some simpler, more mundane shortcuts, like new column (in the model not power query).

[@Baldur1005]

Patrick, we all know. You're not lazy, you're just really efficient :)

[@GuyInACube]

haha People should. But there are a lot of new folks around - have to re-enforce it 👊

[@lukeminikoski]

Where do I get this "Power BI" Cup ?

[@GuyInACube]

We got that from some friends in Europe.

[@lukeminikoski]

@@GuyInACube nice!

[@scottpowell9985]

The thing I struggle with most of all is getting the DAX window to close once I’m done editing the code....if you canvas is completely filled it’s very hard to do....

[@GuyInACube]

Agreed. That is a frustration on our end as well. :(

[@tnclark8012]

Esc will close the formula bar when it has keyboard focus

[@scottpowell9985]

Taylor Clark hi Taylor...but I feel I’ve sometimes lost code changes that way.

[@ayoubbne6922]

These shortcuts are worldwide, in every text editor genarally, not only DAX

[@GuyInACube]

True. But, they are relatively new to Power BI Desktop. We've also found that most people aren't aware that they exist.

[@halo26us]

Great video as always! Hope to meet up at Ignite! (Also Ctrl + D searches through the individual word like Find & Replace)

[@GuyInACube]

ohhhh nice. Thanks for sharing. Adam will be at Ignite. Patrick will be at PASS Summit. Be sure to say hi! 👊

[@dariuszspiewak5624]

Hi Patrick. Thanks for this. I've got a question, though. This is something that frustrates me no end. When I have the multi-cursor active and I want to get out of this mode, I have to press Enter since ESC does not do the trick (but it should). To add oil to the fire, after that, however, it looks like I've been thrown out of the editor, even though the code popup does not close itself. Question: How do I get back into the editor with my cursor using only the keyboard? I'm a keyboard-centric dev and hate using the mouse... Thanks for any enlightenment. By the way, when I edit my code and press Enter it does make a change to the model but---again---I can't get into the editor, even though it stays open before my eyes. Frustrating...

[@tnclark8012]

You can reset the zoom level with Ctrl+Numpad 0. Kind of awkward, but that's that 😁

[@SteiniJonsson]

Ctrl+K, Ctrl+C to comment and Ctrl+K, Ctrl+U to uncomment is standard in all Microsoft dev tools. To block select you can first click on one "corner" of the block to select and then Shift-Alt-Click on the opposite "corner" of the selected text. This is more efficient than click on each line you need to select (if you have to select more than two lines).

[@GuyInACube]

Nice. Love it. :) We had just stumbled on the CTRL + /. None of those are doc'd though. glad the standard stuff works.

[@kwaaikraai]

3:33 Do you folks call that a 'forward slash' over in the US of A? ;) Just kidding - brilliant video, as always! Thanks a lot!

[@GuyInACube]

haha indeed. Thanks for watching! 👊😁

[@TTfromOZ]

Wow!!! So useful!!! And so coooooool!

[@GuyInACube]

Glad you found it useful 👊