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

Calculated table edit queries option not availalbe

Hello,

 

I have a calcualted table that I would like to merge with another table, but Edit Queries option is not available when I right click on the table.  Am I missing anything?

 

 

Shawn

11 REPLIES 11
Highlighted
Super User
Super User

Re: Calculated table edit queries option not availalbe

Can you post a screenshot of what you are looking at?

saltyfish Frequent Visitor
Frequent Visitor

Re: Calculated table edit queries option not availalbe

StoreMonthlyNetSales is a calcuated table.  As you can see from the screenshot below, Edit Queries option is not available.

Screen Shot 2016-04-19 at 12.23.08 PM.png

Super User
Super User

Re: Calculated table edit queries option not availalbe

You are not in the Query Editor!

Query Editor.png

This will open the Query Editor in a New Window!

Query Editor2.png

 

saltyfish Frequent Visitor
Frequent Visitor

Re: Calculated table edit queries option not availalbe

I'm in Query Editor, and the table is not there!

 

Screen Shot 2016-04-19 at 12.56.19 PM.png

Super User
Super User

Re: Calculated table edit queries option not availalbe

Ok I see now in the first screenshot you posted the cells of the table icon are actually shaded a bit blue/gray...

 

You've created this table in PBI to most likely assist in a calculation.

 

This is from a Test File...

PBI Created Table.png

 

You should have the data in that table in another Query though.

 

Can you tell us why you want to merge that table with a query?

 

Super User
Super User

Re: Calculated table edit queries option not availalbe

If you use the Query editor (and it's M-language) for creating columns or additional tables (queries) they can then further be referenced in the query editor and the table view.

 

But it you create your calculated columns or table in the table view (using DAX) they can only be used in the table view. So this is a one-way-street.

 

This can be a bit confusing for beginners and raise the question why the left the option in DAX. An advantage of using the DAX-version is speed at loading for certain calculations.But you pay the price of not being able to reference those items (back) in the query-editor. 

 

So you need to rebuild that table in the query editor (using M) if you need to reference it there. 

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




Super User
Super User

Re: Calculated table edit queries option not availalbe

@ImkeF I just don't get why he needs to merge this DAX created table (which seems to be aggregation of the Daily Sales table to Monthly level) with a Query? (If he aggregates to Annual Sales would he then want to merge that one too?) What's the purpose?

Super User
Super User

Re: Calculated table edit queries option not availalbe

@Sean Agree, I don't get it either and my post wasn't meant to question anything said so far. Actually, I don't have time at the moment to dive into detailed questions like you helpfully raised :-)

 

Just thought it could be helpful to quickly stress out the underlying principles: Think ahead before creating helper tables in the wrong place.

 

 

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




Super User
Super User

Re: Calculated table edit queries option not availalbe

@ImkeF Actually I'm glad you repsonded and clarified this because I wasn't 100% sure - it's a one way street.

 

I suspected it was... but with all the Magic I've seen you do with M... you never know...Smiley Very Happy