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

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