Forum Discussion
Calculated table edit queries option not availalbe
Community ChampionYou are not in the Query Editor!
This will open the Query Editor in a New Window!
I'm in Query Editor, and the table is not there!
- Sean
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...
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?
- ImkeF
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.
