cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chrisknox
Frequent Visitor

You seriously can't copy the DAX formula bar?!?

I need to copy copy a calculated table to a new one.  I want to save the old calculated table.  The "obvious" thing to do is to bring up the calculated table and then copy and edit it under a new name.  But I can't copy or paste in the DAX command box.  Copying the table copies all the data in the table.

 

Why? 

1 ACCEPTED SOLUTION

You can, but there is a bug. The easiest way to make it work every time is to click once in the formula bar, then press control + a, and then copy from there



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

3 REPLIES 3

You can, but there is a bug. The easiest way to make it work every time is to click once in the formula bar, then press control + a, and then copy from there



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

View solution in original post

I just discovered that!  I used CTL-C to copy and it copied.  For whatever reason -- might have been my keyboard -- it had not happened the first time I tried.  A context menu option with a right-click would be nice as well. 

 

Out of curiosity, is there a way to import a DAX script from a text file?

 

There is a bug with the mouse cursor. If you click and drag your mouse in the formula bar, as long as you release the mouse while the pointer is still in the formula bar, it will work. If you release your mouse while the pointer is not inside the formula bar, it doesn't work. 

it is possible to import tax formulas using tabular editor, but it is not a trivial task. Look at my blog articles here https://exceleratorbi.com.au/introduction-to-tabular-editor-for-business-users/



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.