Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

transpose calculated columns

Hi, Can we transpose calculated columns in power bi?
When I go to edit queries, I cannot see the calculated columns.

Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous 

    You need to learn about the difference between M and DAX.

    Calculate column is based on DAX and is part of the data model, it won't appear in edit queries. and in the edit queries, it needs M Langauge and not DAX expressions.

    And you could add a custom column in edit queries and then transpose.

    For further about the difference between M and Dax, you could have a good look at this article.

     

    Best Regards,

    Lin

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, Anonymous 

    You need to learn about the difference between M and DAX.

    Calculate column is based on DAX and is part of the data model, it won't appear in edit queries. and in the edit queries, it needs M Langauge and not DAX expressions.

    And you could add a custom column in edit queries and then transpose.

    For further about the difference between M and Dax, you could have a good look at this article.

     

    Best Regards,

    Lin