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
maracles's avatar
maracles
Icon for Resolver II rankResolver II
10 years ago

ImkeF

Out of curiousity how do you build a similar table in M? I have a similar situation where I've created a table with DAX and on my to-do list is to rebuild as suggested. 

Is there an easy way to create an M formula or would I have to use the Query Editor interface to transform my original table again? 

My DAX is:

Unique AM2 = 
    ADDCOLUMNS(
        SUMMARIZE(
            'AM2', 
            [Order ID]
        ),
       "Word Count", CALCULATE(MAX('AM2'[Word Count])),
       "Fee", CALCULATE(MAX('AM2'[Academic Fee])),
       "First Date", CALCULATE(MIN('AM2'[Assigned Date])) 
)

Thanks. 

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
10 years ago

There is no translator available at the moment who would automatically translate DAX-statements to M. So you would have to do it in the query editor.

 

In this case it is just one dialogue: Group by (check Order ID to group by and the other cols as new cols with their respective aggregation operations (MAX, MIN).