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?
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?
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.
@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?
@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.
@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...