Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

add custom column to table

Hi all,

 

I have a very easy quesion.

 

Is it possible to add a new column which calculated with other 2 column ?

 

My table like as below.

 

I want to change it like that.

 

Finally i'm using Direct Query method, not import data. 😞 BTW if it is possible on import data let me know.

Any idea ? 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous 

    With Power Bi, you will need at least create a column or a measure for the variance to displayed it on the report.

     

    Paul Zheng _ Community Support Team
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

6 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Hi Anonymous 

    try to create a measure 

    Measure = SUMX('Table';[KPI2]-[KPI1])

    for import mode it's enough to create a column

    Column = [KPI2]-[KPI1]
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi az38 

      Actually that's not what i want.

      I don't want to add it like measure. If i create it like measure it going to show on row, i need to show it on columns.

      Does it make sense to you ?

      • az38's avatar
        az38
        Community Champion
        6 years ago

        Anonymous 

        You should be able to use Measure as a column for matrix visual

        Anyway, if you use directquery you also can create a column with some limitations

        Limitations in calculated columns: Calculated columns are limited to being intra-row, as in, they can only refer to values of other columns of the same table, without the use of any aggregate functions. Additionally, the DAX scalar functions, such as LEFT(), that are allowed, are limited to those functions that can be pushed to the underlying source. The functions vary depending upon the exact capabilities of the source. Functions that aren't supported aren't listed in autocomplete when authoring the DAX for a calculated column, and would result in an error if used.

        https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about