cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
maracles Member
Member

Re: Calculated table edit queries option not availalbe

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

Super User
Super User

Re: Calculated table edit queries option not availalbe

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).

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