Forum Discussion

davidwsw's avatar
davidwsw
Frequent Visitor
9 years ago
Solved

Difference between custom column and calculated column

Is there a difference between adding a column in the query editor and adding a column in the data view?

 

Query Editor > Add Column > Add Custom Column:

 

 

 

Data View > Modeling > New Column:

 

 

I noticed that when a column is added using the second method, there is an icon that indicates the calculated column. When I do it using the first method, it is displayed just like any other column.

 

 

 

 

 

 

Need Help
  • v-micsh-msft's avatar
    v-micsh-msft
    9 years ago

    Hi davidwsw,

     

    In addition to the difference of language used to create them, there are also others different parts between them.

    We could take a look at the article below:

    Calculated columns in Power BI Desktop, which explains the main difference between those two columns.

    If any further assistance needed, please post back.

     

    Regards

     

2 Replies

  • BhaveshPatel's avatar
    BhaveshPatel
    Super User
    9 years ago

    Hi David,

     

    Custom columns are created using the PowerQuery M Langauge and are not dax expressions.

     

    Calculated columns are created using DAX Expressions and are part of the data model. 

     

    More info on Custom Colimns and usage at here.

    More info on Calculated Columns is at here

     

     

    Thanks & Regards,

    Bhavesh

  • v-micsh-msft's avatar
    v-micsh-msft
    Microsoft Employee
    9 years ago

    Hi davidwsw,

     

    In addition to the difference of language used to create them, there are also others different parts between them.

    We could take a look at the article below:

    Calculated columns in Power BI Desktop, which explains the main difference between those two columns.

    If any further assistance needed, please post back.

     

    Regards