Quick Tip – Edit #DAX formula in #PowerBI Desktop efficiently

Let me share a quick tip of Power BI today coz I work with Power BI Desktop a lot recently. 😎

What I am going to share in this post is my favorite shortcut key in Power BI Desktop. Honestly, I know just a few shortcuts in Power BI Desktop (much less when comparing to Excel). Nevertheless, the following shortcut is absolutely my all-time favorite, even a lifesaver! What is it?

CTRL+SHIFT+L

What it does?

It allows users to edit word(s) in the formula bar for DAX simultaneously! What does it mean? It means a lot to me. Let’s watch it in a short video!

This is super useful when editing a variable name in the formula! In this way, you won’t miss a variable in the entire DAX formula.

Isn’t it cool? What do you think? Please share your thoughts in the comment below! 😉

Advertisement

About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips and tagged , , . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.