Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Power Query A created Table

hello everyone,

i was wondering if i can transform data a created table from dax

example :

i created a summarzed table from dax ,

can i edit the created table in power query?

  • Hi Anonymous,

     

    You can not edit DAX tables in Power Query. If you want to do some changes, I suggest instead of using SUMMARIZE in DAX, use Group By in Power Query and then do the rest of the transformations there itself.

     

    Did I answer your question? Mark this post as a solution if I did!
    Consider taking a look at my blog: Forecast Period - Graphical Comparison 

2 Replies

  • Shaurya's avatar
    Shaurya
    Memorable Member

    Hi Anonymous,

     

    You can not edit DAX tables in Power Query. If you want to do some changes, I suggest instead of using SUMMARIZE in DAX, use Group By in Power Query and then do the rest of the transformations there itself.

     

    Did I answer your question? Mark this post as a solution if I did!
    Consider taking a look at my blog: Forecast Period - Graphical Comparison 

    • Anonymous's avatar
      Anonymous
      Not applicable

      Oh well its ok i need to use the summarize cause i use measures and calculation in it through different tables but thank you