Forum Discussion

saltyfish's avatar
saltyfish
Regular Visitor
10 years ago

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
Need Help
Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
10 years ago

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

saltyfish's avatar
saltyfish
Regular Visitor
10 years ago

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

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    10 years ago

    You are not in the Query Editor!

    This will open the Query Editor in a New Window!

     

    • saltyfish's avatar
      saltyfish
      Regular Visitor
      10 years ago

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

       

      • Sean's avatar
        Sean
        Icon for Community Champion rankCommunity Champion
        10 years ago

        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?