CRAZY keyboard shortcuts for DAX in Power BI Desktop
Вставка
- Опубліковано 29 жов 2019
- Patrick shows you how to be efficient in Power BI Desktop using keyboard shortcuts for the DAX Editor. It is crazy bananas!
Documentation: docs.microsoft.com/power-bi/d...
Guy in a Cube courses: guyinacu.be/courses
********
LET'S CONNECT!
********
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
Check out my Tools page - guyinacube.com/tools/ - Наука та технологія
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
Some of these are MS Word Shortcuts we've been practicing for years and now they come quite handy for DAX. Thanks mehn.
I listed them all on my notepad. Thank you Patrick!
Gonna have to keep this one to rewatch! So much to learn. So little time.
Love it! 👊 thanks for watching.
Thank you!, more efficient now! and PB rules!
Awesome Patrick! So helpful
Appreciate that. Thanks for watching 👊
These are some amazing shortcuts! This will make DAX so much easier to write!
That was the hope! Glad you found it useful. 👊
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/
Love it! 👊 I have to say, not completely surprised haha. Appreciate you sharing that.
I ❣️ hotkeys... This is awesome!! Thanks for sharing :-)
Alt Power my friend!!!! Awesome cool tips and tricks on shortcuts!!! This is bananas!!!! Thanks for sharing!
haha of course it is :) Appreciate it Gaston! See you at Ignite.
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...
Love it! Glad to hear it is helping you out. Thanks for watching 👊
Very helpful video. Thanks !
Most welcome! Thanks for watching. 👊 Be sure to check some of the other comments. People are offering other tricks as well :)
Thank you!!
Wow!!! So useful!!! And so coooooool!
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.
Very cool! Thank you for sharing 👊
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!
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. 👊
Awesome
Spent a life time learning excel shortcuts
Now on to pbi
Indeed. there are more outside of DAX. But, we have had mixed results with using them. Thanks for watching 👊
Thank you. How can i use "Solver" in Power BI like in Excel?
4:18 This would have saved me so much time when I was first starting out. Now I know!
and knowing is half the battle 👊
This is awesome. I'm a hotkey junkie so this was amazing.
Awesome! There are other keyboard shortcuts outside of DAX as well. Although we have had mix results when using them.
Patrick, we all know. You're not lazy, you're just really efficient :)
haha People should. But there are a lot of new folks around - have to re-enforce it 👊
Instead of Ctrl-Shift-L you can use Ctrl-F2.
Oh nice! Thanks for that 👊
Great video as always! Hope to meet up at Ignite! (Also Ctrl + D searches through the individual word like Find & Replace)
ohhhh nice. Thanks for sharing. Adam will be at Ignite. Patrick will be at PASS Summit. Be sure to say hi! 👊
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).
Nice. Love it. :) We had just stumbled on the CTRL + /. None of those are doc'd though. glad the standard stuff works.
Great but how about some simpler, more mundane shortcuts, like new column (in the model not power query).
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...
You can use Ctrl + KC and Ctrl + KU to coment blocks of code
Nice! Thanks for mentioning that. Although the CTRL + / is a little easier to use.
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.
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.
You can reset the zoom level with Ctrl+Numpad 0. Kind of awkward, but that's that 😁
These shortcuts are worldwide, in every text editor genarally, not only DAX
True. But, they are relatively new to Power BI Desktop. We've also found that most people aren't aware that they exist.
Where do I get this "Power BI" Cup ?
We got that from some friends in Europe.
@@GuyInACube nice!
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!
haha indeed. Thanks for watching! 👊😁
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....
Agreed. That is a frustration on our end as well. :(
Esc will close the formula bar when it has keyboard focus
Taylor Clark hi Taylor...but I feel I’ve sometimes lost code changes that way.
Wow!!! So useful!!! And so coooooool!
Glad you found it useful 👊